package com.crm.model.entity.orderManager;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class OrderRawDataExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public OrderRawDataExample() {
        oredCriteria = new ArrayList<>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andOrderRawDataIdIsNull() {
            addCriterion("order_raw_data_id is null");
            return (Criteria) this;
        }

        public Criteria andOrderRawDataIdIsNotNull() {
            addCriterion("order_raw_data_id is not null");
            return (Criteria) this;
        }

        public Criteria andOrderRawDataIdEqualTo(String value) {
            addCriterion("order_raw_data_id =", value, "orderRawDataId");
            return (Criteria) this;
        }

        public Criteria andOrderRawDataIdNotEqualTo(String value) {
            addCriterion("order_raw_data_id <>", value, "orderRawDataId");
            return (Criteria) this;
        }

        public Criteria andOrderRawDataIdGreaterThan(String value) {
            addCriterion("order_raw_data_id >", value, "orderRawDataId");
            return (Criteria) this;
        }

        public Criteria andOrderRawDataIdGreaterThanOrEqualTo(String value) {
            addCriterion("order_raw_data_id >=", value, "orderRawDataId");
            return (Criteria) this;
        }

        public Criteria andOrderRawDataIdLessThan(String value) {
            addCriterion("order_raw_data_id <", value, "orderRawDataId");
            return (Criteria) this;
        }

        public Criteria andOrderRawDataIdLessThanOrEqualTo(String value) {
            addCriterion("order_raw_data_id <=", value, "orderRawDataId");
            return (Criteria) this;
        }

        public Criteria andOrderRawDataIdLike(String value) {
            addCriterion("order_raw_data_id like", value, "orderRawDataId");
            return (Criteria) this;
        }

        public Criteria andOrderRawDataIdNotLike(String value) {
            addCriterion("order_raw_data_id not like", value, "orderRawDataId");
            return (Criteria) this;
        }

        public Criteria andOrderRawDataIdIn(List<String> values) {
            addCriterion("order_raw_data_id in", values, "orderRawDataId");
            return (Criteria) this;
        }

        public Criteria andOrderRawDataIdNotIn(List<String> values) {
            addCriterion("order_raw_data_id not in", values, "orderRawDataId");
            return (Criteria) this;
        }

        public Criteria andOrderRawDataIdBetween(String value1, String value2) {
            addCriterion("order_raw_data_id between", value1, value2, "orderRawDataId");
            return (Criteria) this;
        }

        public Criteria andOrderRawDataIdNotBetween(String value1, String value2) {
            addCriterion("order_raw_data_id not between", value1, value2, "orderRawDataId");
            return (Criteria) this;
        }

        public Criteria andOrderCreateTmIsNull() {
            addCriterion("order_create_tm is null");
            return (Criteria) this;
        }

        public Criteria andOrderCreateTmIsNotNull() {
            addCriterion("order_create_tm is not null");
            return (Criteria) this;
        }

        public Criteria andOrderCreateTmEqualTo(String value) {
            addCriterion("order_create_tm =", value, "orderCreateTm");
            return (Criteria) this;
        }

        public Criteria andOrderCreateTmNotEqualTo(String value) {
            addCriterion("order_create_tm <>", value, "orderCreateTm");
            return (Criteria) this;
        }

        public Criteria andOrderCreateTmGreaterThan(String value) {
            addCriterion("order_create_tm >", value, "orderCreateTm");
            return (Criteria) this;
        }

        public Criteria andOrderCreateTmGreaterThanOrEqualTo(String value) {
            addCriterion("order_create_tm >=", value, "orderCreateTm");
            return (Criteria) this;
        }

        public Criteria andOrderCreateTmLessThan(String value) {
            addCriterion("order_create_tm <", value, "orderCreateTm");
            return (Criteria) this;
        }

        public Criteria andOrderCreateTmLessThanOrEqualTo(String value) {
            addCriterion("order_create_tm <=", value, "orderCreateTm");
            return (Criteria) this;
        }

        public Criteria andOrderCreateTmLike(String value) {
            addCriterion("order_create_tm like", value, "orderCreateTm");
            return (Criteria) this;
        }

        public Criteria andOrderCreateTmNotLike(String value) {
            addCriterion("order_create_tm not like", value, "orderCreateTm");
            return (Criteria) this;
        }

        public Criteria andOrderCreateTmIn(List<String> values) {
            addCriterion("order_create_tm in", values, "orderCreateTm");
            return (Criteria) this;
        }

        public Criteria andOrderCreateTmNotIn(List<String> values) {
            addCriterion("order_create_tm not in", values, "orderCreateTm");
            return (Criteria) this;
        }

        public Criteria andOrderCreateTmBetween(String value1, String value2) {
            addCriterion("order_create_tm between", value1, value2, "orderCreateTm");
            return (Criteria) this;
        }

        public Criteria andOrderCreateTmNotBetween(String value1, String value2) {
            addCriterion("order_create_tm not between", value1, value2, "orderCreateTm");
            return (Criteria) this;
        }

        public Criteria andCompanyIsNull() {
            addCriterion("company is null");
            return (Criteria) this;
        }

        public Criteria andCompanyIsNotNull() {
            addCriterion("company is not null");
            return (Criteria) this;
        }

        public Criteria andCompanyEqualTo(String value) {
            addCriterion("company =", value, "company");
            return (Criteria) this;
        }

        public Criteria andCompanyNotEqualTo(String value) {
            addCriterion("company <>", value, "company");
            return (Criteria) this;
        }

        public Criteria andCompanyGreaterThan(String value) {
            addCriterion("company >", value, "company");
            return (Criteria) this;
        }

        public Criteria andCompanyGreaterThanOrEqualTo(String value) {
            addCriterion("company >=", value, "company");
            return (Criteria) this;
        }

        public Criteria andCompanyLessThan(String value) {
            addCriterion("company <", value, "company");
            return (Criteria) this;
        }

        public Criteria andCompanyLessThanOrEqualTo(String value) {
            addCriterion("company <=", value, "company");
            return (Criteria) this;
        }

        public Criteria andCompanyLike(String value) {
            addCriterion("company like", value, "company");
            return (Criteria) this;
        }

        public Criteria andCompanyNotLike(String value) {
            addCriterion("company not like", value, "company");
            return (Criteria) this;
        }

        public Criteria andCompanyIn(List<String> values) {
            addCriterion("company in", values, "company");
            return (Criteria) this;
        }

        public Criteria andCompanyNotIn(List<String> values) {
            addCriterion("company not in", values, "company");
            return (Criteria) this;
        }

        public Criteria andCompanyBetween(String value1, String value2) {
            addCriterion("company between", value1, value2, "company");
            return (Criteria) this;
        }

        public Criteria andCompanyNotBetween(String value1, String value2) {
            addCriterion("company not between", value1, value2, "company");
            return (Criteria) this;
        }

        public Criteria andOwnerIsNull() {
            addCriterion("owner is null");
            return (Criteria) this;
        }

        public Criteria andOwnerIsNotNull() {
            addCriterion("owner is not null");
            return (Criteria) this;
        }

        public Criteria andOwnerEqualTo(String value) {
            addCriterion("owner =", value, "owner");
            return (Criteria) this;
        }

        public Criteria andOwnerNotEqualTo(String value) {
            addCriterion("owner <>", value, "owner");
            return (Criteria) this;
        }

        public Criteria andOwnerGreaterThan(String value) {
            addCriterion("owner >", value, "owner");
            return (Criteria) this;
        }

        public Criteria andOwnerGreaterThanOrEqualTo(String value) {
            addCriterion("owner >=", value, "owner");
            return (Criteria) this;
        }

        public Criteria andOwnerLessThan(String value) {
            addCriterion("owner <", value, "owner");
            return (Criteria) this;
        }

        public Criteria andOwnerLessThanOrEqualTo(String value) {
            addCriterion("owner <=", value, "owner");
            return (Criteria) this;
        }

        public Criteria andOwnerLike(String value) {
            addCriterion("owner like", value, "owner");
            return (Criteria) this;
        }

        public Criteria andOwnerNotLike(String value) {
            addCriterion("owner not like", value, "owner");
            return (Criteria) this;
        }

        public Criteria andOwnerIn(List<String> values) {
            addCriterion("owner in", values, "owner");
            return (Criteria) this;
        }

        public Criteria andOwnerNotIn(List<String> values) {
            addCriterion("owner not in", values, "owner");
            return (Criteria) this;
        }

        public Criteria andOwnerBetween(String value1, String value2) {
            addCriterion("owner between", value1, value2, "owner");
            return (Criteria) this;
        }

        public Criteria andOwnerNotBetween(String value1, String value2) {
            addCriterion("owner not between", value1, value2, "owner");
            return (Criteria) this;
        }

        public Criteria andSonOwnerIsNull() {
            addCriterion("son_owner is null");
            return (Criteria) this;
        }

        public Criteria andSonOwnerIsNotNull() {
            addCriterion("son_owner is not null");
            return (Criteria) this;
        }

        public Criteria andSonOwnerEqualTo(String value) {
            addCriterion("son_owner =", value, "sonOwner");
            return (Criteria) this;
        }

        public Criteria andSonOwnerNotEqualTo(String value) {
            addCriterion("son_owner <>", value, "sonOwner");
            return (Criteria) this;
        }

        public Criteria andSonOwnerGreaterThan(String value) {
            addCriterion("son_owner >", value, "sonOwner");
            return (Criteria) this;
        }

        public Criteria andSonOwnerGreaterThanOrEqualTo(String value) {
            addCriterion("son_owner >=", value, "sonOwner");
            return (Criteria) this;
        }

        public Criteria andSonOwnerLessThan(String value) {
            addCriterion("son_owner <", value, "sonOwner");
            return (Criteria) this;
        }

        public Criteria andSonOwnerLessThanOrEqualTo(String value) {
            addCriterion("son_owner <=", value, "sonOwner");
            return (Criteria) this;
        }

        public Criteria andSonOwnerLike(String value) {
            addCriterion("son_owner like", value, "sonOwner");
            return (Criteria) this;
        }

        public Criteria andSonOwnerNotLike(String value) {
            addCriterion("son_owner not like", value, "sonOwner");
            return (Criteria) this;
        }

        public Criteria andSonOwnerIn(List<String> values) {
            addCriterion("son_owner in", values, "sonOwner");
            return (Criteria) this;
        }

        public Criteria andSonOwnerNotIn(List<String> values) {
            addCriterion("son_owner not in", values, "sonOwner");
            return (Criteria) this;
        }

        public Criteria andSonOwnerBetween(String value1, String value2) {
            addCriterion("son_owner between", value1, value2, "sonOwner");
            return (Criteria) this;
        }

        public Criteria andSonOwnerNotBetween(String value1, String value2) {
            addCriterion("son_owner not between", value1, value2, "sonOwner");
            return (Criteria) this;
        }

        public Criteria andOrderStatusIsNull() {
            addCriterion("order_status is null");
            return (Criteria) this;
        }

        public Criteria andOrderStatusIsNotNull() {
            addCriterion("order_status is not null");
            return (Criteria) this;
        }

        public Criteria andOrderStatusEqualTo(String value) {
            addCriterion("order_status =", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusNotEqualTo(String value) {
            addCriterion("order_status <>", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusGreaterThan(String value) {
            addCriterion("order_status >", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusGreaterThanOrEqualTo(String value) {
            addCriterion("order_status >=", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusLessThan(String value) {
            addCriterion("order_status <", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusLessThanOrEqualTo(String value) {
            addCriterion("order_status <=", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusLike(String value) {
            addCriterion("order_status like", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusNotLike(String value) {
            addCriterion("order_status not like", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusIn(List<String> values) {
            addCriterion("order_status in", values, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusNotIn(List<String> values) {
            addCriterion("order_status not in", values, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusBetween(String value1, String value2) {
            addCriterion("order_status between", value1, value2, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusNotBetween(String value1, String value2) {
            addCriterion("order_status not between", value1, value2, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderTypeIsNull() {
            addCriterion("order_type is null");
            return (Criteria) this;
        }

        public Criteria andOrderTypeIsNotNull() {
            addCriterion("order_type is not null");
            return (Criteria) this;
        }

        public Criteria andOrderTypeEqualTo(String value) {
            addCriterion("order_type =", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNotEqualTo(String value) {
            addCriterion("order_type <>", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeGreaterThan(String value) {
            addCriterion("order_type >", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeGreaterThanOrEqualTo(String value) {
            addCriterion("order_type >=", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeLessThan(String value) {
            addCriterion("order_type <", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeLessThanOrEqualTo(String value) {
            addCriterion("order_type <=", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeLike(String value) {
            addCriterion("order_type like", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNotLike(String value) {
            addCriterion("order_type not like", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeIn(List<String> values) {
            addCriterion("order_type in", values, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNotIn(List<String> values) {
            addCriterion("order_type not in", values, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeBetween(String value1, String value2) {
            addCriterion("order_type between", value1, value2, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNotBetween(String value1, String value2) {
            addCriterion("order_type not between", value1, value2, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderNumberIsNull() {
            addCriterion("order_number is null");
            return (Criteria) this;
        }

        public Criteria andOrderNumberIsNotNull() {
            addCriterion("order_number is not null");
            return (Criteria) this;
        }

        public Criteria andOrderNumberEqualTo(String value) {
            addCriterion("order_number =", value, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andOrderNumberNotEqualTo(String value) {
            addCriterion("order_number <>", value, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andOrderNumberGreaterThan(String value) {
            addCriterion("order_number >", value, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andOrderNumberGreaterThanOrEqualTo(String value) {
            addCriterion("order_number >=", value, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andOrderNumberLessThan(String value) {
            addCriterion("order_number <", value, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andOrderNumberLessThanOrEqualTo(String value) {
            addCriterion("order_number <=", value, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andOrderNumberLike(String value) {
            addCriterion("order_number like", value, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andOrderNumberNotLike(String value) {
            addCriterion("order_number not like", value, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andOrderNumberIn(List<String> values) {
            addCriterion("order_number in", values, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andOrderNumberNotIn(List<String> values) {
            addCriterion("order_number not in", values, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andOrderNumberBetween(String value1, String value2) {
            addCriterion("order_number between", value1, value2, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andOrderNumberNotBetween(String value1, String value2) {
            addCriterion("order_number not between", value1, value2, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andCustomerNameIsNull() {
            addCriterion("customer_name is null");
            return (Criteria) this;
        }

        public Criteria andCustomerNameIsNotNull() {
            addCriterion("customer_name is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerNameEqualTo(String value) {
            addCriterion("customer_name =", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameNotEqualTo(String value) {
            addCriterion("customer_name <>", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameGreaterThan(String value) {
            addCriterion("customer_name >", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameGreaterThanOrEqualTo(String value) {
            addCriterion("customer_name >=", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameLessThan(String value) {
            addCriterion("customer_name <", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameLessThanOrEqualTo(String value) {
            addCriterion("customer_name <=", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameLike(String value) {
            addCriterion("customer_name like", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameNotLike(String value) {
            addCriterion("customer_name not like", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameIn(List<String> values) {
            addCriterion("customer_name in", values, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameNotIn(List<String> values) {
            addCriterion("customer_name not in", values, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameBetween(String value1, String value2) {
            addCriterion("customer_name between", value1, value2, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameNotBetween(String value1, String value2) {
            addCriterion("customer_name not between", value1, value2, "customerName");
            return (Criteria) this;
        }

        public Criteria andOwnerContactPersonIsNull() {
            addCriterion("owner_contact_person is null");
            return (Criteria) this;
        }

        public Criteria andOwnerContactPersonIsNotNull() {
            addCriterion("owner_contact_person is not null");
            return (Criteria) this;
        }

        public Criteria andOwnerContactPersonEqualTo(String value) {
            addCriterion("owner_contact_person =", value, "ownerContactPerson");
            return (Criteria) this;
        }

        public Criteria andOwnerContactPersonNotEqualTo(String value) {
            addCriterion("owner_contact_person <>", value, "ownerContactPerson");
            return (Criteria) this;
        }

        public Criteria andOwnerContactPersonGreaterThan(String value) {
            addCriterion("owner_contact_person >", value, "ownerContactPerson");
            return (Criteria) this;
        }

        public Criteria andOwnerContactPersonGreaterThanOrEqualTo(String value) {
            addCriterion("owner_contact_person >=", value, "ownerContactPerson");
            return (Criteria) this;
        }

        public Criteria andOwnerContactPersonLessThan(String value) {
            addCriterion("owner_contact_person <", value, "ownerContactPerson");
            return (Criteria) this;
        }

        public Criteria andOwnerContactPersonLessThanOrEqualTo(String value) {
            addCriterion("owner_contact_person <=", value, "ownerContactPerson");
            return (Criteria) this;
        }

        public Criteria andOwnerContactPersonLike(String value) {
            addCriterion("owner_contact_person like", value, "ownerContactPerson");
            return (Criteria) this;
        }

        public Criteria andOwnerContactPersonNotLike(String value) {
            addCriterion("owner_contact_person not like", value, "ownerContactPerson");
            return (Criteria) this;
        }

        public Criteria andOwnerContactPersonIn(List<String> values) {
            addCriterion("owner_contact_person in", values, "ownerContactPerson");
            return (Criteria) this;
        }

        public Criteria andOwnerContactPersonNotIn(List<String> values) {
            addCriterion("owner_contact_person not in", values, "ownerContactPerson");
            return (Criteria) this;
        }

        public Criteria andOwnerContactPersonBetween(String value1, String value2) {
            addCriterion("owner_contact_person between", value1, value2, "ownerContactPerson");
            return (Criteria) this;
        }

        public Criteria andOwnerContactPersonNotBetween(String value1, String value2) {
            addCriterion("owner_contact_person not between", value1, value2, "ownerContactPerson");
            return (Criteria) this;
        }

        public Criteria andContractNumberIsNull() {
            addCriterion("contract_number is null");
            return (Criteria) this;
        }

        public Criteria andContractNumberIsNotNull() {
            addCriterion("contract_number is not null");
            return (Criteria) this;
        }

        public Criteria andContractNumberEqualTo(String value) {
            addCriterion("contract_number =", value, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberNotEqualTo(String value) {
            addCriterion("contract_number <>", value, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberGreaterThan(String value) {
            addCriterion("contract_number >", value, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberGreaterThanOrEqualTo(String value) {
            addCriterion("contract_number >=", value, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberLessThan(String value) {
            addCriterion("contract_number <", value, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberLessThanOrEqualTo(String value) {
            addCriterion("contract_number <=", value, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberLike(String value) {
            addCriterion("contract_number like", value, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberNotLike(String value) {
            addCriterion("contract_number not like", value, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberIn(List<String> values) {
            addCriterion("contract_number in", values, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberNotIn(List<String> values) {
            addCriterion("contract_number not in", values, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberBetween(String value1, String value2) {
            addCriterion("contract_number between", value1, value2, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andContractNumberNotBetween(String value1, String value2) {
            addCriterion("contract_number not between", value1, value2, "contractNumber");
            return (Criteria) this;
        }

        public Criteria andBuyProductIsNull() {
            addCriterion("buy_product is null");
            return (Criteria) this;
        }

        public Criteria andBuyProductIsNotNull() {
            addCriterion("buy_product is not null");
            return (Criteria) this;
        }

        public Criteria andBuyProductEqualTo(String value) {
            addCriterion("buy_product =", value, "buyProduct");
            return (Criteria) this;
        }

        public Criteria andBuyProductNotEqualTo(String value) {
            addCriterion("buy_product <>", value, "buyProduct");
            return (Criteria) this;
        }

        public Criteria andBuyProductGreaterThan(String value) {
            addCriterion("buy_product >", value, "buyProduct");
            return (Criteria) this;
        }

        public Criteria andBuyProductGreaterThanOrEqualTo(String value) {
            addCriterion("buy_product >=", value, "buyProduct");
            return (Criteria) this;
        }

        public Criteria andBuyProductLessThan(String value) {
            addCriterion("buy_product <", value, "buyProduct");
            return (Criteria) this;
        }

        public Criteria andBuyProductLessThanOrEqualTo(String value) {
            addCriterion("buy_product <=", value, "buyProduct");
            return (Criteria) this;
        }

        public Criteria andBuyProductLike(String value) {
            addCriterion("buy_product like", value, "buyProduct");
            return (Criteria) this;
        }

        public Criteria andBuyProductNotLike(String value) {
            addCriterion("buy_product not like", value, "buyProduct");
            return (Criteria) this;
        }

        public Criteria andBuyProductIn(List<String> values) {
            addCriterion("buy_product in", values, "buyProduct");
            return (Criteria) this;
        }

        public Criteria andBuyProductNotIn(List<String> values) {
            addCriterion("buy_product not in", values, "buyProduct");
            return (Criteria) this;
        }

        public Criteria andBuyProductBetween(String value1, String value2) {
            addCriterion("buy_product between", value1, value2, "buyProduct");
            return (Criteria) this;
        }

        public Criteria andBuyProductNotBetween(String value1, String value2) {
            addCriterion("buy_product not between", value1, value2, "buyProduct");
            return (Criteria) this;
        }

        public Criteria andUnitPriceOfProductIsNull() {
            addCriterion("unit_price_of_product is null");
            return (Criteria) this;
        }

        public Criteria andUnitPriceOfProductIsNotNull() {
            addCriterion("unit_price_of_product is not null");
            return (Criteria) this;
        }

        public Criteria andUnitPriceOfProductEqualTo(String value) {
            addCriterion("unit_price_of_product =", value, "unitPriceOfProduct");
            return (Criteria) this;
        }

        public Criteria andUnitPriceOfProductNotEqualTo(String value) {
            addCriterion("unit_price_of_product <>", value, "unitPriceOfProduct");
            return (Criteria) this;
        }

        public Criteria andUnitPriceOfProductGreaterThan(String value) {
            addCriterion("unit_price_of_product >", value, "unitPriceOfProduct");
            return (Criteria) this;
        }

        public Criteria andUnitPriceOfProductGreaterThanOrEqualTo(String value) {
            addCriterion("unit_price_of_product >=", value, "unitPriceOfProduct");
            return (Criteria) this;
        }

        public Criteria andUnitPriceOfProductLessThan(String value) {
            addCriterion("unit_price_of_product <", value, "unitPriceOfProduct");
            return (Criteria) this;
        }

        public Criteria andUnitPriceOfProductLessThanOrEqualTo(String value) {
            addCriterion("unit_price_of_product <=", value, "unitPriceOfProduct");
            return (Criteria) this;
        }

        public Criteria andUnitPriceOfProductLike(String value) {
            addCriterion("unit_price_of_product like", value, "unitPriceOfProduct");
            return (Criteria) this;
        }

        public Criteria andUnitPriceOfProductNotLike(String value) {
            addCriterion("unit_price_of_product not like", value, "unitPriceOfProduct");
            return (Criteria) this;
        }

        public Criteria andUnitPriceOfProductIn(List<String> values) {
            addCriterion("unit_price_of_product in", values, "unitPriceOfProduct");
            return (Criteria) this;
        }

        public Criteria andUnitPriceOfProductNotIn(List<String> values) {
            addCriterion("unit_price_of_product not in", values, "unitPriceOfProduct");
            return (Criteria) this;
        }

        public Criteria andUnitPriceOfProductBetween(String value1, String value2) {
            addCriterion("unit_price_of_product between", value1, value2, "unitPriceOfProduct");
            return (Criteria) this;
        }

        public Criteria andUnitPriceOfProductNotBetween(String value1, String value2) {
            addCriterion("unit_price_of_product not between", value1, value2, "unitPriceOfProduct");
            return (Criteria) this;
        }

        public Criteria andCouponCodeIsNull() {
            addCriterion("coupon_code is null");
            return (Criteria) this;
        }

        public Criteria andCouponCodeIsNotNull() {
            addCriterion("coupon_code is not null");
            return (Criteria) this;
        }

        public Criteria andCouponCodeEqualTo(String value) {
            addCriterion("coupon_code =", value, "couponCode");
            return (Criteria) this;
        }

        public Criteria andCouponCodeNotEqualTo(String value) {
            addCriterion("coupon_code <>", value, "couponCode");
            return (Criteria) this;
        }

        public Criteria andCouponCodeGreaterThan(String value) {
            addCriterion("coupon_code >", value, "couponCode");
            return (Criteria) this;
        }

        public Criteria andCouponCodeGreaterThanOrEqualTo(String value) {
            addCriterion("coupon_code >=", value, "couponCode");
            return (Criteria) this;
        }

        public Criteria andCouponCodeLessThan(String value) {
            addCriterion("coupon_code <", value, "couponCode");
            return (Criteria) this;
        }

        public Criteria andCouponCodeLessThanOrEqualTo(String value) {
            addCriterion("coupon_code <=", value, "couponCode");
            return (Criteria) this;
        }

        public Criteria andCouponCodeLike(String value) {
            addCriterion("coupon_code like", value, "couponCode");
            return (Criteria) this;
        }

        public Criteria andCouponCodeNotLike(String value) {
            addCriterion("coupon_code not like", value, "couponCode");
            return (Criteria) this;
        }

        public Criteria andCouponCodeIn(List<String> values) {
            addCriterion("coupon_code in", values, "couponCode");
            return (Criteria) this;
        }

        public Criteria andCouponCodeNotIn(List<String> values) {
            addCriterion("coupon_code not in", values, "couponCode");
            return (Criteria) this;
        }

        public Criteria andCouponCodeBetween(String value1, String value2) {
            addCriterion("coupon_code between", value1, value2, "couponCode");
            return (Criteria) this;
        }

        public Criteria andCouponCodeNotBetween(String value1, String value2) {
            addCriterion("coupon_code not between", value1, value2, "couponCode");
            return (Criteria) this;
        }

        public Criteria andDiscountAmountIsNull() {
            addCriterion("discount_amount is null");
            return (Criteria) this;
        }

        public Criteria andDiscountAmountIsNotNull() {
            addCriterion("discount_amount is not null");
            return (Criteria) this;
        }

        public Criteria andDiscountAmountEqualTo(String value) {
            addCriterion("discount_amount =", value, "discountAmount");
            return (Criteria) this;
        }

        public Criteria andDiscountAmountNotEqualTo(String value) {
            addCriterion("discount_amount <>", value, "discountAmount");
            return (Criteria) this;
        }

        public Criteria andDiscountAmountGreaterThan(String value) {
            addCriterion("discount_amount >", value, "discountAmount");
            return (Criteria) this;
        }

        public Criteria andDiscountAmountGreaterThanOrEqualTo(String value) {
            addCriterion("discount_amount >=", value, "discountAmount");
            return (Criteria) this;
        }

        public Criteria andDiscountAmountLessThan(String value) {
            addCriterion("discount_amount <", value, "discountAmount");
            return (Criteria) this;
        }

        public Criteria andDiscountAmountLessThanOrEqualTo(String value) {
            addCriterion("discount_amount <=", value, "discountAmount");
            return (Criteria) this;
        }

        public Criteria andDiscountAmountLike(String value) {
            addCriterion("discount_amount like", value, "discountAmount");
            return (Criteria) this;
        }

        public Criteria andDiscountAmountNotLike(String value) {
            addCriterion("discount_amount not like", value, "discountAmount");
            return (Criteria) this;
        }

        public Criteria andDiscountAmountIn(List<String> values) {
            addCriterion("discount_amount in", values, "discountAmount");
            return (Criteria) this;
        }

        public Criteria andDiscountAmountNotIn(List<String> values) {
            addCriterion("discount_amount not in", values, "discountAmount");
            return (Criteria) this;
        }

        public Criteria andDiscountAmountBetween(String value1, String value2) {
            addCriterion("discount_amount between", value1, value2, "discountAmount");
            return (Criteria) this;
        }

        public Criteria andDiscountAmountNotBetween(String value1, String value2) {
            addCriterion("discount_amount not between", value1, value2, "discountAmount");
            return (Criteria) this;
        }

        public Criteria andDiscountDescriptionIsNull() {
            addCriterion("discount_description is null");
            return (Criteria) this;
        }

        public Criteria andDiscountDescriptionIsNotNull() {
            addCriterion("discount_description is not null");
            return (Criteria) this;
        }

        public Criteria andDiscountDescriptionEqualTo(String value) {
            addCriterion("discount_description =", value, "discountDescription");
            return (Criteria) this;
        }

        public Criteria andDiscountDescriptionNotEqualTo(String value) {
            addCriterion("discount_description <>", value, "discountDescription");
            return (Criteria) this;
        }

        public Criteria andDiscountDescriptionGreaterThan(String value) {
            addCriterion("discount_description >", value, "discountDescription");
            return (Criteria) this;
        }

        public Criteria andDiscountDescriptionGreaterThanOrEqualTo(String value) {
            addCriterion("discount_description >=", value, "discountDescription");
            return (Criteria) this;
        }

        public Criteria andDiscountDescriptionLessThan(String value) {
            addCriterion("discount_description <", value, "discountDescription");
            return (Criteria) this;
        }

        public Criteria andDiscountDescriptionLessThanOrEqualTo(String value) {
            addCriterion("discount_description <=", value, "discountDescription");
            return (Criteria) this;
        }

        public Criteria andDiscountDescriptionLike(String value) {
            addCriterion("discount_description like", value, "discountDescription");
            return (Criteria) this;
        }

        public Criteria andDiscountDescriptionNotLike(String value) {
            addCriterion("discount_description not like", value, "discountDescription");
            return (Criteria) this;
        }

        public Criteria andDiscountDescriptionIn(List<String> values) {
            addCriterion("discount_description in", values, "discountDescription");
            return (Criteria) this;
        }

        public Criteria andDiscountDescriptionNotIn(List<String> values) {
            addCriterion("discount_description not in", values, "discountDescription");
            return (Criteria) this;
        }

        public Criteria andDiscountDescriptionBetween(String value1, String value2) {
            addCriterion("discount_description between", value1, value2, "discountDescription");
            return (Criteria) this;
        }

        public Criteria andDiscountDescriptionNotBetween(String value1, String value2) {
            addCriterion("discount_description not between", value1, value2, "discountDescription");
            return (Criteria) this;
        }

        public Criteria andActualTransactionPriceIsNull() {
            addCriterion("actual_transaction_price is null");
            return (Criteria) this;
        }

        public Criteria andActualTransactionPriceIsNotNull() {
            addCriterion("actual_transaction_price is not null");
            return (Criteria) this;
        }

        public Criteria andActualTransactionPriceEqualTo(String value) {
            addCriterion("actual_transaction_price =", value, "actualTransactionPrice");
            return (Criteria) this;
        }

        public Criteria andActualTransactionPriceNotEqualTo(String value) {
            addCriterion("actual_transaction_price <>", value, "actualTransactionPrice");
            return (Criteria) this;
        }

        public Criteria andActualTransactionPriceGreaterThan(String value) {
            addCriterion("actual_transaction_price >", value, "actualTransactionPrice");
            return (Criteria) this;
        }

        public Criteria andActualTransactionPriceGreaterThanOrEqualTo(String value) {
            addCriterion("actual_transaction_price >=", value, "actualTransactionPrice");
            return (Criteria) this;
        }

        public Criteria andActualTransactionPriceLessThan(String value) {
            addCriterion("actual_transaction_price <", value, "actualTransactionPrice");
            return (Criteria) this;
        }

        public Criteria andActualTransactionPriceLessThanOrEqualTo(String value) {
            addCriterion("actual_transaction_price <=", value, "actualTransactionPrice");
            return (Criteria) this;
        }

        public Criteria andActualTransactionPriceLike(String value) {
            addCriterion("actual_transaction_price like", value, "actualTransactionPrice");
            return (Criteria) this;
        }

        public Criteria andActualTransactionPriceNotLike(String value) {
            addCriterion("actual_transaction_price not like", value, "actualTransactionPrice");
            return (Criteria) this;
        }

        public Criteria andActualTransactionPriceIn(List<String> values) {
            addCriterion("actual_transaction_price in", values, "actualTransactionPrice");
            return (Criteria) this;
        }

        public Criteria andActualTransactionPriceNotIn(List<String> values) {
            addCriterion("actual_transaction_price not in", values, "actualTransactionPrice");
            return (Criteria) this;
        }

        public Criteria andActualTransactionPriceBetween(String value1, String value2) {
            addCriterion("actual_transaction_price between", value1, value2, "actualTransactionPrice");
            return (Criteria) this;
        }

        public Criteria andActualTransactionPriceNotBetween(String value1, String value2) {
            addCriterion("actual_transaction_price not between", value1, value2, "actualTransactionPrice");
            return (Criteria) this;
        }

        public Criteria andPaymentMethodIsNull() {
            addCriterion("payment_method is null");
            return (Criteria) this;
        }

        public Criteria andPaymentMethodIsNotNull() {
            addCriterion("payment_method is not null");
            return (Criteria) this;
        }

        public Criteria andPaymentMethodEqualTo(String value) {
            addCriterion("payment_method =", value, "paymentMethod");
            return (Criteria) this;
        }

        public Criteria andPaymentMethodNotEqualTo(String value) {
            addCriterion("payment_method <>", value, "paymentMethod");
            return (Criteria) this;
        }

        public Criteria andPaymentMethodGreaterThan(String value) {
            addCriterion("payment_method >", value, "paymentMethod");
            return (Criteria) this;
        }

        public Criteria andPaymentMethodGreaterThanOrEqualTo(String value) {
            addCriterion("payment_method >=", value, "paymentMethod");
            return (Criteria) this;
        }

        public Criteria andPaymentMethodLessThan(String value) {
            addCriterion("payment_method <", value, "paymentMethod");
            return (Criteria) this;
        }

        public Criteria andPaymentMethodLessThanOrEqualTo(String value) {
            addCriterion("payment_method <=", value, "paymentMethod");
            return (Criteria) this;
        }

        public Criteria andPaymentMethodLike(String value) {
            addCriterion("payment_method like", value, "paymentMethod");
            return (Criteria) this;
        }

        public Criteria andPaymentMethodNotLike(String value) {
            addCriterion("payment_method not like", value, "paymentMethod");
            return (Criteria) this;
        }

        public Criteria andPaymentMethodIn(List<String> values) {
            addCriterion("payment_method in", values, "paymentMethod");
            return (Criteria) this;
        }

        public Criteria andPaymentMethodNotIn(List<String> values) {
            addCriterion("payment_method not in", values, "paymentMethod");
            return (Criteria) this;
        }

        public Criteria andPaymentMethodBetween(String value1, String value2) {
            addCriterion("payment_method between", value1, value2, "paymentMethod");
            return (Criteria) this;
        }

        public Criteria andPaymentMethodNotBetween(String value1, String value2) {
            addCriterion("payment_method not between", value1, value2, "paymentMethod");
            return (Criteria) this;
        }

        public Criteria andOrderDiscountIsNull() {
            addCriterion("order_discount is null");
            return (Criteria) this;
        }

        public Criteria andOrderDiscountIsNotNull() {
            addCriterion("order_discount is not null");
            return (Criteria) this;
        }

        public Criteria andOrderDiscountEqualTo(String value) {
            addCriterion("order_discount =", value, "orderDiscount");
            return (Criteria) this;
        }

        public Criteria andOrderDiscountNotEqualTo(String value) {
            addCriterion("order_discount <>", value, "orderDiscount");
            return (Criteria) this;
        }

        public Criteria andOrderDiscountGreaterThan(String value) {
            addCriterion("order_discount >", value, "orderDiscount");
            return (Criteria) this;
        }

        public Criteria andOrderDiscountGreaterThanOrEqualTo(String value) {
            addCriterion("order_discount >=", value, "orderDiscount");
            return (Criteria) this;
        }

        public Criteria andOrderDiscountLessThan(String value) {
            addCriterion("order_discount <", value, "orderDiscount");
            return (Criteria) this;
        }

        public Criteria andOrderDiscountLessThanOrEqualTo(String value) {
            addCriterion("order_discount <=", value, "orderDiscount");
            return (Criteria) this;
        }

        public Criteria andOrderDiscountLike(String value) {
            addCriterion("order_discount like", value, "orderDiscount");
            return (Criteria) this;
        }

        public Criteria andOrderDiscountNotLike(String value) {
            addCriterion("order_discount not like", value, "orderDiscount");
            return (Criteria) this;
        }

        public Criteria andOrderDiscountIn(List<String> values) {
            addCriterion("order_discount in", values, "orderDiscount");
            return (Criteria) this;
        }

        public Criteria andOrderDiscountNotIn(List<String> values) {
            addCriterion("order_discount not in", values, "orderDiscount");
            return (Criteria) this;
        }

        public Criteria andOrderDiscountBetween(String value1, String value2) {
            addCriterion("order_discount between", value1, value2, "orderDiscount");
            return (Criteria) this;
        }

        public Criteria andOrderDiscountNotBetween(String value1, String value2) {
            addCriterion("order_discount not between", value1, value2, "orderDiscount");
            return (Criteria) this;
        }

        public Criteria andPaybackStatusIsNull() {
            addCriterion("payback_status is null");
            return (Criteria) this;
        }

        public Criteria andPaybackStatusIsNotNull() {
            addCriterion("payback_status is not null");
            return (Criteria) this;
        }

        public Criteria andPaybackStatusEqualTo(String value) {
            addCriterion("payback_status =", value, "paybackStatus");
            return (Criteria) this;
        }

        public Criteria andPaybackStatusNotEqualTo(String value) {
            addCriterion("payback_status <>", value, "paybackStatus");
            return (Criteria) this;
        }

        public Criteria andPaybackStatusGreaterThan(String value) {
            addCriterion("payback_status >", value, "paybackStatus");
            return (Criteria) this;
        }

        public Criteria andPaybackStatusGreaterThanOrEqualTo(String value) {
            addCriterion("payback_status >=", value, "paybackStatus");
            return (Criteria) this;
        }

        public Criteria andPaybackStatusLessThan(String value) {
            addCriterion("payback_status <", value, "paybackStatus");
            return (Criteria) this;
        }

        public Criteria andPaybackStatusLessThanOrEqualTo(String value) {
            addCriterion("payback_status <=", value, "paybackStatus");
            return (Criteria) this;
        }

        public Criteria andPaybackStatusLike(String value) {
            addCriterion("payback_status like", value, "paybackStatus");
            return (Criteria) this;
        }

        public Criteria andPaybackStatusNotLike(String value) {
            addCriterion("payback_status not like", value, "paybackStatus");
            return (Criteria) this;
        }

        public Criteria andPaybackStatusIn(List<String> values) {
            addCriterion("payback_status in", values, "paybackStatus");
            return (Criteria) this;
        }

        public Criteria andPaybackStatusNotIn(List<String> values) {
            addCriterion("payback_status not in", values, "paybackStatus");
            return (Criteria) this;
        }

        public Criteria andPaybackStatusBetween(String value1, String value2) {
            addCriterion("payback_status between", value1, value2, "paybackStatus");
            return (Criteria) this;
        }

        public Criteria andPaybackStatusNotBetween(String value1, String value2) {
            addCriterion("payback_status not between", value1, value2, "paybackStatus");
            return (Criteria) this;
        }

        public Criteria andBusinessOpportunityIsNull() {
            addCriterion("business_opportunity is null");
            return (Criteria) this;
        }

        public Criteria andBusinessOpportunityIsNotNull() {
            addCriterion("business_opportunity is not null");
            return (Criteria) this;
        }

        public Criteria andBusinessOpportunityEqualTo(String value) {
            addCriterion("business_opportunity =", value, "businessOpportunity");
            return (Criteria) this;
        }

        public Criteria andBusinessOpportunityNotEqualTo(String value) {
            addCriterion("business_opportunity <>", value, "businessOpportunity");
            return (Criteria) this;
        }

        public Criteria andBusinessOpportunityGreaterThan(String value) {
            addCriterion("business_opportunity >", value, "businessOpportunity");
            return (Criteria) this;
        }

        public Criteria andBusinessOpportunityGreaterThanOrEqualTo(String value) {
            addCriterion("business_opportunity >=", value, "businessOpportunity");
            return (Criteria) this;
        }

        public Criteria andBusinessOpportunityLessThan(String value) {
            addCriterion("business_opportunity <", value, "businessOpportunity");
            return (Criteria) this;
        }

        public Criteria andBusinessOpportunityLessThanOrEqualTo(String value) {
            addCriterion("business_opportunity <=", value, "businessOpportunity");
            return (Criteria) this;
        }

        public Criteria andBusinessOpportunityLike(String value) {
            addCriterion("business_opportunity like", value, "businessOpportunity");
            return (Criteria) this;
        }

        public Criteria andBusinessOpportunityNotLike(String value) {
            addCriterion("business_opportunity not like", value, "businessOpportunity");
            return (Criteria) this;
        }

        public Criteria andBusinessOpportunityIn(List<String> values) {
            addCriterion("business_opportunity in", values, "businessOpportunity");
            return (Criteria) this;
        }

        public Criteria andBusinessOpportunityNotIn(List<String> values) {
            addCriterion("business_opportunity not in", values, "businessOpportunity");
            return (Criteria) this;
        }

        public Criteria andBusinessOpportunityBetween(String value1, String value2) {
            addCriterion("business_opportunity between", value1, value2, "businessOpportunity");
            return (Criteria) this;
        }

        public Criteria andBusinessOpportunityNotBetween(String value1, String value2) {
            addCriterion("business_opportunity not between", value1, value2, "businessOpportunity");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNull() {
            addCriterion("remark is null");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNotNull() {
            addCriterion("remark is not null");
            return (Criteria) this;
        }

        public Criteria andRemarkEqualTo(String value) {
            addCriterion("remark =", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotEqualTo(String value) {
            addCriterion("remark <>", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThan(String value) {
            addCriterion("remark >", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("remark >=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThan(String value) {
            addCriterion("remark <", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThanOrEqualTo(String value) {
            addCriterion("remark <=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLike(String value) {
            addCriterion("remark like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotLike(String value) {
            addCriterion("remark not like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkIn(List<String> values) {
            addCriterion("remark in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotIn(List<String> values) {
            addCriterion("remark not in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkBetween(String value1, String value2) {
            addCriterion("remark between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotBetween(String value1, String value2) {
            addCriterion("remark not between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andWhetherHangIsNull() {
            addCriterion("whether_hang is null");
            return (Criteria) this;
        }

        public Criteria andWhetherHangIsNotNull() {
            addCriterion("whether_hang is not null");
            return (Criteria) this;
        }

        public Criteria andWhetherHangEqualTo(String value) {
            addCriterion("whether_hang =", value, "whetherHang");
            return (Criteria) this;
        }

        public Criteria andWhetherHangNotEqualTo(String value) {
            addCriterion("whether_hang <>", value, "whetherHang");
            return (Criteria) this;
        }

        public Criteria andWhetherHangGreaterThan(String value) {
            addCriterion("whether_hang >", value, "whetherHang");
            return (Criteria) this;
        }

        public Criteria andWhetherHangGreaterThanOrEqualTo(String value) {
            addCriterion("whether_hang >=", value, "whetherHang");
            return (Criteria) this;
        }

        public Criteria andWhetherHangLessThan(String value) {
            addCriterion("whether_hang <", value, "whetherHang");
            return (Criteria) this;
        }

        public Criteria andWhetherHangLessThanOrEqualTo(String value) {
            addCriterion("whether_hang <=", value, "whetherHang");
            return (Criteria) this;
        }

        public Criteria andWhetherHangLike(String value) {
            addCriterion("whether_hang like", value, "whetherHang");
            return (Criteria) this;
        }

        public Criteria andWhetherHangNotLike(String value) {
            addCriterion("whether_hang not like", value, "whetherHang");
            return (Criteria) this;
        }

        public Criteria andWhetherHangIn(List<String> values) {
            addCriterion("whether_hang in", values, "whetherHang");
            return (Criteria) this;
        }

        public Criteria andWhetherHangNotIn(List<String> values) {
            addCriterion("whether_hang not in", values, "whetherHang");
            return (Criteria) this;
        }

        public Criteria andWhetherHangBetween(String value1, String value2) {
            addCriterion("whether_hang between", value1, value2, "whetherHang");
            return (Criteria) this;
        }

        public Criteria andWhetherHangNotBetween(String value1, String value2) {
            addCriterion("whether_hang not between", value1, value2, "whetherHang");
            return (Criteria) this;
        }

        public Criteria andWhetherRefundIsNull() {
            addCriterion("whether_refund is null");
            return (Criteria) this;
        }

        public Criteria andWhetherRefundIsNotNull() {
            addCriterion("whether_refund is not null");
            return (Criteria) this;
        }

        public Criteria andWhetherRefundEqualTo(String value) {
            addCriterion("whether_refund =", value, "whetherRefund");
            return (Criteria) this;
        }

        public Criteria andWhetherRefundNotEqualTo(String value) {
            addCriterion("whether_refund <>", value, "whetherRefund");
            return (Criteria) this;
        }

        public Criteria andWhetherRefundGreaterThan(String value) {
            addCriterion("whether_refund >", value, "whetherRefund");
            return (Criteria) this;
        }

        public Criteria andWhetherRefundGreaterThanOrEqualTo(String value) {
            addCriterion("whether_refund >=", value, "whetherRefund");
            return (Criteria) this;
        }

        public Criteria andWhetherRefundLessThan(String value) {
            addCriterion("whether_refund <", value, "whetherRefund");
            return (Criteria) this;
        }

        public Criteria andWhetherRefundLessThanOrEqualTo(String value) {
            addCriterion("whether_refund <=", value, "whetherRefund");
            return (Criteria) this;
        }

        public Criteria andWhetherRefundLike(String value) {
            addCriterion("whether_refund like", value, "whetherRefund");
            return (Criteria) this;
        }

        public Criteria andWhetherRefundNotLike(String value) {
            addCriterion("whether_refund not like", value, "whetherRefund");
            return (Criteria) this;
        }

        public Criteria andWhetherRefundIn(List<String> values) {
            addCriterion("whether_refund in", values, "whetherRefund");
            return (Criteria) this;
        }

        public Criteria andWhetherRefundNotIn(List<String> values) {
            addCriterion("whether_refund not in", values, "whetherRefund");
            return (Criteria) this;
        }

        public Criteria andWhetherRefundBetween(String value1, String value2) {
            addCriterion("whether_refund between", value1, value2, "whetherRefund");
            return (Criteria) this;
        }

        public Criteria andWhetherRefundNotBetween(String value1, String value2) {
            addCriterion("whether_refund not between", value1, value2, "whetherRefund");
            return (Criteria) this;
        }

        public Criteria andContractStartDateIsNull() {
            addCriterion("contract_start_date is null");
            return (Criteria) this;
        }

        public Criteria andContractStartDateIsNotNull() {
            addCriterion("contract_start_date is not null");
            return (Criteria) this;
        }

        public Criteria andContractStartDateEqualTo(String value) {
            addCriterion("contract_start_date =", value, "contractStartDate");
            return (Criteria) this;
        }

        public Criteria andContractStartDateNotEqualTo(String value) {
            addCriterion("contract_start_date <>", value, "contractStartDate");
            return (Criteria) this;
        }

        public Criteria andContractStartDateGreaterThan(String value) {
            addCriterion("contract_start_date >", value, "contractStartDate");
            return (Criteria) this;
        }

        public Criteria andContractStartDateGreaterThanOrEqualTo(String value) {
            addCriterion("contract_start_date >=", value, "contractStartDate");
            return (Criteria) this;
        }

        public Criteria andContractStartDateLessThan(String value) {
            addCriterion("contract_start_date <", value, "contractStartDate");
            return (Criteria) this;
        }

        public Criteria andContractStartDateLessThanOrEqualTo(String value) {
            addCriterion("contract_start_date <=", value, "contractStartDate");
            return (Criteria) this;
        }

        public Criteria andContractStartDateLike(String value) {
            addCriterion("contract_start_date like", value, "contractStartDate");
            return (Criteria) this;
        }

        public Criteria andContractStartDateNotLike(String value) {
            addCriterion("contract_start_date not like", value, "contractStartDate");
            return (Criteria) this;
        }

        public Criteria andContractStartDateIn(List<String> values) {
            addCriterion("contract_start_date in", values, "contractStartDate");
            return (Criteria) this;
        }

        public Criteria andContractStartDateNotIn(List<String> values) {
            addCriterion("contract_start_date not in", values, "contractStartDate");
            return (Criteria) this;
        }

        public Criteria andContractStartDateBetween(String value1, String value2) {
            addCriterion("contract_start_date between", value1, value2, "contractStartDate");
            return (Criteria) this;
        }

        public Criteria andContractStartDateNotBetween(String value1, String value2) {
            addCriterion("contract_start_date not between", value1, value2, "contractStartDate");
            return (Criteria) this;
        }

        public Criteria andContractEndDateIsNull() {
            addCriterion("contract_end_date is null");
            return (Criteria) this;
        }

        public Criteria andContractEndDateIsNotNull() {
            addCriterion("contract_end_date is not null");
            return (Criteria) this;
        }

        public Criteria andContractEndDateEqualTo(String value) {
            addCriterion("contract_end_date =", value, "contractEndDate");
            return (Criteria) this;
        }

        public Criteria andContractEndDateNotEqualTo(String value) {
            addCriterion("contract_end_date <>", value, "contractEndDate");
            return (Criteria) this;
        }

        public Criteria andContractEndDateGreaterThan(String value) {
            addCriterion("contract_end_date >", value, "contractEndDate");
            return (Criteria) this;
        }

        public Criteria andContractEndDateGreaterThanOrEqualTo(String value) {
            addCriterion("contract_end_date >=", value, "contractEndDate");
            return (Criteria) this;
        }

        public Criteria andContractEndDateLessThan(String value) {
            addCriterion("contract_end_date <", value, "contractEndDate");
            return (Criteria) this;
        }

        public Criteria andContractEndDateLessThanOrEqualTo(String value) {
            addCriterion("contract_end_date <=", value, "contractEndDate");
            return (Criteria) this;
        }

        public Criteria andContractEndDateLike(String value) {
            addCriterion("contract_end_date like", value, "contractEndDate");
            return (Criteria) this;
        }

        public Criteria andContractEndDateNotLike(String value) {
            addCriterion("contract_end_date not like", value, "contractEndDate");
            return (Criteria) this;
        }

        public Criteria andContractEndDateIn(List<String> values) {
            addCriterion("contract_end_date in", values, "contractEndDate");
            return (Criteria) this;
        }

        public Criteria andContractEndDateNotIn(List<String> values) {
            addCriterion("contract_end_date not in", values, "contractEndDate");
            return (Criteria) this;
        }

        public Criteria andContractEndDateBetween(String value1, String value2) {
            addCriterion("contract_end_date between", value1, value2, "contractEndDate");
            return (Criteria) this;
        }

        public Criteria andContractEndDateNotBetween(String value1, String value2) {
            addCriterion("contract_end_date not between", value1, value2, "contractEndDate");
            return (Criteria) this;
        }

        public Criteria andMasterMemberContractIsNull() {
            addCriterion("master_member_contract is null");
            return (Criteria) this;
        }

        public Criteria andMasterMemberContractIsNotNull() {
            addCriterion("master_member_contract is not null");
            return (Criteria) this;
        }

        public Criteria andMasterMemberContractEqualTo(String value) {
            addCriterion("master_member_contract =", value, "masterMemberContract");
            return (Criteria) this;
        }

        public Criteria andMasterMemberContractNotEqualTo(String value) {
            addCriterion("master_member_contract <>", value, "masterMemberContract");
            return (Criteria) this;
        }

        public Criteria andMasterMemberContractGreaterThan(String value) {
            addCriterion("master_member_contract >", value, "masterMemberContract");
            return (Criteria) this;
        }

        public Criteria andMasterMemberContractGreaterThanOrEqualTo(String value) {
            addCriterion("master_member_contract >=", value, "masterMemberContract");
            return (Criteria) this;
        }

        public Criteria andMasterMemberContractLessThan(String value) {
            addCriterion("master_member_contract <", value, "masterMemberContract");
            return (Criteria) this;
        }

        public Criteria andMasterMemberContractLessThanOrEqualTo(String value) {
            addCriterion("master_member_contract <=", value, "masterMemberContract");
            return (Criteria) this;
        }

        public Criteria andMasterMemberContractLike(String value) {
            addCriterion("master_member_contract like", value, "masterMemberContract");
            return (Criteria) this;
        }

        public Criteria andMasterMemberContractNotLike(String value) {
            addCriterion("master_member_contract not like", value, "masterMemberContract");
            return (Criteria) this;
        }

        public Criteria andMasterMemberContractIn(List<String> values) {
            addCriterion("master_member_contract in", values, "masterMemberContract");
            return (Criteria) this;
        }

        public Criteria andMasterMemberContractNotIn(List<String> values) {
            addCriterion("master_member_contract not in", values, "masterMemberContract");
            return (Criteria) this;
        }

        public Criteria andMasterMemberContractBetween(String value1, String value2) {
            addCriterion("master_member_contract between", value1, value2, "masterMemberContract");
            return (Criteria) this;
        }

        public Criteria andMasterMemberContractNotBetween(String value1, String value2) {
            addCriterion("master_member_contract not between", value1, value2, "masterMemberContract");
            return (Criteria) this;
        }

        public Criteria andMembershipCardLevelIsNull() {
            addCriterion("membership_card_level is null");
            return (Criteria) this;
        }

        public Criteria andMembershipCardLevelIsNotNull() {
            addCriterion("membership_card_level is not null");
            return (Criteria) this;
        }

        public Criteria andMembershipCardLevelEqualTo(String value) {
            addCriterion("membership_card_level =", value, "membershipCardLevel");
            return (Criteria) this;
        }

        public Criteria andMembershipCardLevelNotEqualTo(String value) {
            addCriterion("membership_card_level <>", value, "membershipCardLevel");
            return (Criteria) this;
        }

        public Criteria andMembershipCardLevelGreaterThan(String value) {
            addCriterion("membership_card_level >", value, "membershipCardLevel");
            return (Criteria) this;
        }

        public Criteria andMembershipCardLevelGreaterThanOrEqualTo(String value) {
            addCriterion("membership_card_level >=", value, "membershipCardLevel");
            return (Criteria) this;
        }

        public Criteria andMembershipCardLevelLessThan(String value) {
            addCriterion("membership_card_level <", value, "membershipCardLevel");
            return (Criteria) this;
        }

        public Criteria andMembershipCardLevelLessThanOrEqualTo(String value) {
            addCriterion("membership_card_level <=", value, "membershipCardLevel");
            return (Criteria) this;
        }

        public Criteria andMembershipCardLevelLike(String value) {
            addCriterion("membership_card_level like", value, "membershipCardLevel");
            return (Criteria) this;
        }

        public Criteria andMembershipCardLevelNotLike(String value) {
            addCriterion("membership_card_level not like", value, "membershipCardLevel");
            return (Criteria) this;
        }

        public Criteria andMembershipCardLevelIn(List<String> values) {
            addCriterion("membership_card_level in", values, "membershipCardLevel");
            return (Criteria) this;
        }

        public Criteria andMembershipCardLevelNotIn(List<String> values) {
            addCriterion("membership_card_level not in", values, "membershipCardLevel");
            return (Criteria) this;
        }

        public Criteria andMembershipCardLevelBetween(String value1, String value2) {
            addCriterion("membership_card_level between", value1, value2, "membershipCardLevel");
            return (Criteria) this;
        }

        public Criteria andMembershipCardLevelNotBetween(String value1, String value2) {
            addCriterion("membership_card_level not between", value1, value2, "membershipCardLevel");
            return (Criteria) this;
        }

        public Criteria andArrivalMoneyMethodIsNull() {
            addCriterion("arrival_money_method is null");
            return (Criteria) this;
        }

        public Criteria andArrivalMoneyMethodIsNotNull() {
            addCriterion("arrival_money_method is not null");
            return (Criteria) this;
        }

        public Criteria andArrivalMoneyMethodEqualTo(String value) {
            addCriterion("arrival_money_method =", value, "arrivalMoneyMethod");
            return (Criteria) this;
        }

        public Criteria andArrivalMoneyMethodNotEqualTo(String value) {
            addCriterion("arrival_money_method <>", value, "arrivalMoneyMethod");
            return (Criteria) this;
        }

        public Criteria andArrivalMoneyMethodGreaterThan(String value) {
            addCriterion("arrival_money_method >", value, "arrivalMoneyMethod");
            return (Criteria) this;
        }

        public Criteria andArrivalMoneyMethodGreaterThanOrEqualTo(String value) {
            addCriterion("arrival_money_method >=", value, "arrivalMoneyMethod");
            return (Criteria) this;
        }

        public Criteria andArrivalMoneyMethodLessThan(String value) {
            addCriterion("arrival_money_method <", value, "arrivalMoneyMethod");
            return (Criteria) this;
        }

        public Criteria andArrivalMoneyMethodLessThanOrEqualTo(String value) {
            addCriterion("arrival_money_method <=", value, "arrivalMoneyMethod");
            return (Criteria) this;
        }

        public Criteria andArrivalMoneyMethodLike(String value) {
            addCriterion("arrival_money_method like", value, "arrivalMoneyMethod");
            return (Criteria) this;
        }

        public Criteria andArrivalMoneyMethodNotLike(String value) {
            addCriterion("arrival_money_method not like", value, "arrivalMoneyMethod");
            return (Criteria) this;
        }

        public Criteria andArrivalMoneyMethodIn(List<String> values) {
            addCriterion("arrival_money_method in", values, "arrivalMoneyMethod");
            return (Criteria) this;
        }

        public Criteria andArrivalMoneyMethodNotIn(List<String> values) {
            addCriterion("arrival_money_method not in", values, "arrivalMoneyMethod");
            return (Criteria) this;
        }

        public Criteria andArrivalMoneyMethodBetween(String value1, String value2) {
            addCriterion("arrival_money_method between", value1, value2, "arrivalMoneyMethod");
            return (Criteria) this;
        }

        public Criteria andArrivalMoneyMethodNotBetween(String value1, String value2) {
            addCriterion("arrival_money_method not between", value1, value2, "arrivalMoneyMethod");
            return (Criteria) this;
        }

        public Criteria andSourceChannelIsNull() {
            addCriterion("source_channel is null");
            return (Criteria) this;
        }

        public Criteria andSourceChannelIsNotNull() {
            addCriterion("source_channel is not null");
            return (Criteria) this;
        }

        public Criteria andSourceChannelEqualTo(String value) {
            addCriterion("source_channel =", value, "sourceChannel");
            return (Criteria) this;
        }

        public Criteria andSourceChannelNotEqualTo(String value) {
            addCriterion("source_channel <>", value, "sourceChannel");
            return (Criteria) this;
        }

        public Criteria andSourceChannelGreaterThan(String value) {
            addCriterion("source_channel >", value, "sourceChannel");
            return (Criteria) this;
        }

        public Criteria andSourceChannelGreaterThanOrEqualTo(String value) {
            addCriterion("source_channel >=", value, "sourceChannel");
            return (Criteria) this;
        }

        public Criteria andSourceChannelLessThan(String value) {
            addCriterion("source_channel <", value, "sourceChannel");
            return (Criteria) this;
        }

        public Criteria andSourceChannelLessThanOrEqualTo(String value) {
            addCriterion("source_channel <=", value, "sourceChannel");
            return (Criteria) this;
        }

        public Criteria andSourceChannelLike(String value) {
            addCriterion("source_channel like", value, "sourceChannel");
            return (Criteria) this;
        }

        public Criteria andSourceChannelNotLike(String value) {
            addCriterion("source_channel not like", value, "sourceChannel");
            return (Criteria) this;
        }

        public Criteria andSourceChannelIn(List<String> values) {
            addCriterion("source_channel in", values, "sourceChannel");
            return (Criteria) this;
        }

        public Criteria andSourceChannelNotIn(List<String> values) {
            addCriterion("source_channel not in", values, "sourceChannel");
            return (Criteria) this;
        }

        public Criteria andSourceChannelBetween(String value1, String value2) {
            addCriterion("source_channel between", value1, value2, "sourceChannel");
            return (Criteria) this;
        }

        public Criteria andSourceChannelNotBetween(String value1, String value2) {
            addCriterion("source_channel not between", value1, value2, "sourceChannel");
            return (Criteria) this;
        }

        public Criteria andBindMobilePhoneNumIsNull() {
            addCriterion("bind_mobile_phone_num is null");
            return (Criteria) this;
        }

        public Criteria andBindMobilePhoneNumIsNotNull() {
            addCriterion("bind_mobile_phone_num is not null");
            return (Criteria) this;
        }

        public Criteria andBindMobilePhoneNumEqualTo(String value) {
            addCriterion("bind_mobile_phone_num =", value, "bindMobilePhoneNum");
            return (Criteria) this;
        }

        public Criteria andBindMobilePhoneNumNotEqualTo(String value) {
            addCriterion("bind_mobile_phone_num <>", value, "bindMobilePhoneNum");
            return (Criteria) this;
        }

        public Criteria andBindMobilePhoneNumGreaterThan(String value) {
            addCriterion("bind_mobile_phone_num >", value, "bindMobilePhoneNum");
            return (Criteria) this;
        }

        public Criteria andBindMobilePhoneNumGreaterThanOrEqualTo(String value) {
            addCriterion("bind_mobile_phone_num >=", value, "bindMobilePhoneNum");
            return (Criteria) this;
        }

        public Criteria andBindMobilePhoneNumLessThan(String value) {
            addCriterion("bind_mobile_phone_num <", value, "bindMobilePhoneNum");
            return (Criteria) this;
        }

        public Criteria andBindMobilePhoneNumLessThanOrEqualTo(String value) {
            addCriterion("bind_mobile_phone_num <=", value, "bindMobilePhoneNum");
            return (Criteria) this;
        }

        public Criteria andBindMobilePhoneNumLike(String value) {
            addCriterion("bind_mobile_phone_num like", value, "bindMobilePhoneNum");
            return (Criteria) this;
        }

        public Criteria andBindMobilePhoneNumNotLike(String value) {
            addCriterion("bind_mobile_phone_num not like", value, "bindMobilePhoneNum");
            return (Criteria) this;
        }

        public Criteria andBindMobilePhoneNumIn(List<String> values) {
            addCriterion("bind_mobile_phone_num in", values, "bindMobilePhoneNum");
            return (Criteria) this;
        }

        public Criteria andBindMobilePhoneNumNotIn(List<String> values) {
            addCriterion("bind_mobile_phone_num not in", values, "bindMobilePhoneNum");
            return (Criteria) this;
        }

        public Criteria andBindMobilePhoneNumBetween(String value1, String value2) {
            addCriterion("bind_mobile_phone_num between", value1, value2, "bindMobilePhoneNum");
            return (Criteria) this;
        }

        public Criteria andBindMobilePhoneNumNotBetween(String value1, String value2) {
            addCriterion("bind_mobile_phone_num not between", value1, value2, "bindMobilePhoneNum");
            return (Criteria) this;
        }

        public Criteria andContactPersonIsNull() {
            addCriterion("contact_person is null");
            return (Criteria) this;
        }

        public Criteria andContactPersonIsNotNull() {
            addCriterion("contact_person is not null");
            return (Criteria) this;
        }

        public Criteria andContactPersonEqualTo(String value) {
            addCriterion("contact_person =", value, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andContactPersonNotEqualTo(String value) {
            addCriterion("contact_person <>", value, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andContactPersonGreaterThan(String value) {
            addCriterion("contact_person >", value, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andContactPersonGreaterThanOrEqualTo(String value) {
            addCriterion("contact_person >=", value, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andContactPersonLessThan(String value) {
            addCriterion("contact_person <", value, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andContactPersonLessThanOrEqualTo(String value) {
            addCriterion("contact_person <=", value, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andContactPersonLike(String value) {
            addCriterion("contact_person like", value, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andContactPersonNotLike(String value) {
            addCriterion("contact_person not like", value, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andContactPersonIn(List<String> values) {
            addCriterion("contact_person in", values, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andContactPersonNotIn(List<String> values) {
            addCriterion("contact_person not in", values, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andContactPersonBetween(String value1, String value2) {
            addCriterion("contact_person between", value1, value2, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andContactPersonNotBetween(String value1, String value2) {
            addCriterion("contact_person not between", value1, value2, "contactPerson");
            return (Criteria) this;
        }

        public Criteria andUidUserNumberIsNull() {
            addCriterion("uid_user_number is null");
            return (Criteria) this;
        }

        public Criteria andUidUserNumberIsNotNull() {
            addCriterion("uid_user_number is not null");
            return (Criteria) this;
        }

        public Criteria andUidUserNumberEqualTo(String value) {
            addCriterion("uid_user_number =", value, "uidUserNumber");
            return (Criteria) this;
        }

        public Criteria andUidUserNumberNotEqualTo(String value) {
            addCriterion("uid_user_number <>", value, "uidUserNumber");
            return (Criteria) this;
        }

        public Criteria andUidUserNumberGreaterThan(String value) {
            addCriterion("uid_user_number >", value, "uidUserNumber");
            return (Criteria) this;
        }

        public Criteria andUidUserNumberGreaterThanOrEqualTo(String value) {
            addCriterion("uid_user_number >=", value, "uidUserNumber");
            return (Criteria) this;
        }

        public Criteria andUidUserNumberLessThan(String value) {
            addCriterion("uid_user_number <", value, "uidUserNumber");
            return (Criteria) this;
        }

        public Criteria andUidUserNumberLessThanOrEqualTo(String value) {
            addCriterion("uid_user_number <=", value, "uidUserNumber");
            return (Criteria) this;
        }

        public Criteria andUidUserNumberLike(String value) {
            addCriterion("uid_user_number like", value, "uidUserNumber");
            return (Criteria) this;
        }

        public Criteria andUidUserNumberNotLike(String value) {
            addCriterion("uid_user_number not like", value, "uidUserNumber");
            return (Criteria) this;
        }

        public Criteria andUidUserNumberIn(List<String> values) {
            addCriterion("uid_user_number in", values, "uidUserNumber");
            return (Criteria) this;
        }

        public Criteria andUidUserNumberNotIn(List<String> values) {
            addCriterion("uid_user_number not in", values, "uidUserNumber");
            return (Criteria) this;
        }

        public Criteria andUidUserNumberBetween(String value1, String value2) {
            addCriterion("uid_user_number between", value1, value2, "uidUserNumber");
            return (Criteria) this;
        }

        public Criteria andUidUserNumberNotBetween(String value1, String value2) {
            addCriterion("uid_user_number not between", value1, value2, "uidUserNumber");
            return (Criteria) this;
        }

        public Criteria andWechatIdIsNull() {
            addCriterion("wechat_id is null");
            return (Criteria) this;
        }

        public Criteria andWechatIdIsNotNull() {
            addCriterion("wechat_id is not null");
            return (Criteria) this;
        }

        public Criteria andWechatIdEqualTo(String value) {
            addCriterion("wechat_id =", value, "wechatId");
            return (Criteria) this;
        }

        public Criteria andWechatIdNotEqualTo(String value) {
            addCriterion("wechat_id <>", value, "wechatId");
            return (Criteria) this;
        }

        public Criteria andWechatIdGreaterThan(String value) {
            addCriterion("wechat_id >", value, "wechatId");
            return (Criteria) this;
        }

        public Criteria andWechatIdGreaterThanOrEqualTo(String value) {
            addCriterion("wechat_id >=", value, "wechatId");
            return (Criteria) this;
        }

        public Criteria andWechatIdLessThan(String value) {
            addCriterion("wechat_id <", value, "wechatId");
            return (Criteria) this;
        }

        public Criteria andWechatIdLessThanOrEqualTo(String value) {
            addCriterion("wechat_id <=", value, "wechatId");
            return (Criteria) this;
        }

        public Criteria andWechatIdLike(String value) {
            addCriterion("wechat_id like", value, "wechatId");
            return (Criteria) this;
        }

        public Criteria andWechatIdNotLike(String value) {
            addCriterion("wechat_id not like", value, "wechatId");
            return (Criteria) this;
        }

        public Criteria andWechatIdIn(List<String> values) {
            addCriterion("wechat_id in", values, "wechatId");
            return (Criteria) this;
        }

        public Criteria andWechatIdNotIn(List<String> values) {
            addCriterion("wechat_id not in", values, "wechatId");
            return (Criteria) this;
        }

        public Criteria andWechatIdBetween(String value1, String value2) {
            addCriterion("wechat_id between", value1, value2, "wechatId");
            return (Criteria) this;
        }

        public Criteria andWechatIdNotBetween(String value1, String value2) {
            addCriterion("wechat_id not between", value1, value2, "wechatId");
            return (Criteria) this;
        }

        public Criteria andMerchantOrderNumberIsNull() {
            addCriterion("merchant_order_number is null");
            return (Criteria) this;
        }

        public Criteria andMerchantOrderNumberIsNotNull() {
            addCriterion("merchant_order_number is not null");
            return (Criteria) this;
        }

        public Criteria andMerchantOrderNumberEqualTo(String value) {
            addCriterion("merchant_order_number =", value, "merchantOrderNumber");
            return (Criteria) this;
        }

        public Criteria andMerchantOrderNumberNotEqualTo(String value) {
            addCriterion("merchant_order_number <>", value, "merchantOrderNumber");
            return (Criteria) this;
        }

        public Criteria andMerchantOrderNumberGreaterThan(String value) {
            addCriterion("merchant_order_number >", value, "merchantOrderNumber");
            return (Criteria) this;
        }

        public Criteria andMerchantOrderNumberGreaterThanOrEqualTo(String value) {
            addCriterion("merchant_order_number >=", value, "merchantOrderNumber");
            return (Criteria) this;
        }

        public Criteria andMerchantOrderNumberLessThan(String value) {
            addCriterion("merchant_order_number <", value, "merchantOrderNumber");
            return (Criteria) this;
        }

        public Criteria andMerchantOrderNumberLessThanOrEqualTo(String value) {
            addCriterion("merchant_order_number <=", value, "merchantOrderNumber");
            return (Criteria) this;
        }

        public Criteria andMerchantOrderNumberLike(String value) {
            addCriterion("merchant_order_number like", value, "merchantOrderNumber");
            return (Criteria) this;
        }

        public Criteria andMerchantOrderNumberNotLike(String value) {
            addCriterion("merchant_order_number not like", value, "merchantOrderNumber");
            return (Criteria) this;
        }

        public Criteria andMerchantOrderNumberIn(List<String> values) {
            addCriterion("merchant_order_number in", values, "merchantOrderNumber");
            return (Criteria) this;
        }

        public Criteria andMerchantOrderNumberNotIn(List<String> values) {
            addCriterion("merchant_order_number not in", values, "merchantOrderNumber");
            return (Criteria) this;
        }

        public Criteria andMerchantOrderNumberBetween(String value1, String value2) {
            addCriterion("merchant_order_number between", value1, value2, "merchantOrderNumber");
            return (Criteria) this;
        }

        public Criteria andMerchantOrderNumberNotBetween(String value1, String value2) {
            addCriterion("merchant_order_number not between", value1, value2, "merchantOrderNumber");
            return (Criteria) this;
        }

        public Criteria andProductCodeIsNull() {
            addCriterion("product_code is null");
            return (Criteria) this;
        }

        public Criteria andProductCodeIsNotNull() {
            addCriterion("product_code is not null");
            return (Criteria) this;
        }

        public Criteria andProductCodeEqualTo(String value) {
            addCriterion("product_code =", value, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeNotEqualTo(String value) {
            addCriterion("product_code <>", value, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeGreaterThan(String value) {
            addCriterion("product_code >", value, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeGreaterThanOrEqualTo(String value) {
            addCriterion("product_code >=", value, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeLessThan(String value) {
            addCriterion("product_code <", value, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeLessThanOrEqualTo(String value) {
            addCriterion("product_code <=", value, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeLike(String value) {
            addCriterion("product_code like", value, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeNotLike(String value) {
            addCriterion("product_code not like", value, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeIn(List<String> values) {
            addCriterion("product_code in", values, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeNotIn(List<String> values) {
            addCriterion("product_code not in", values, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeBetween(String value1, String value2) {
            addCriterion("product_code between", value1, value2, "productCode");
            return (Criteria) this;
        }

        public Criteria andProductCodeNotBetween(String value1, String value2) {
            addCriterion("product_code not between", value1, value2, "productCode");
            return (Criteria) this;
        }

        public Criteria andCustomerMasterOwnerIsNull() {
            addCriterion("customer_master_owner is null");
            return (Criteria) this;
        }

        public Criteria andCustomerMasterOwnerIsNotNull() {
            addCriterion("customer_master_owner is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerMasterOwnerEqualTo(String value) {
            addCriterion("customer_master_owner =", value, "customerMasterOwner");
            return (Criteria) this;
        }

        public Criteria andCustomerMasterOwnerNotEqualTo(String value) {
            addCriterion("customer_master_owner <>", value, "customerMasterOwner");
            return (Criteria) this;
        }

        public Criteria andCustomerMasterOwnerGreaterThan(String value) {
            addCriterion("customer_master_owner >", value, "customerMasterOwner");
            return (Criteria) this;
        }

        public Criteria andCustomerMasterOwnerGreaterThanOrEqualTo(String value) {
            addCriterion("customer_master_owner >=", value, "customerMasterOwner");
            return (Criteria) this;
        }

        public Criteria andCustomerMasterOwnerLessThan(String value) {
            addCriterion("customer_master_owner <", value, "customerMasterOwner");
            return (Criteria) this;
        }

        public Criteria andCustomerMasterOwnerLessThanOrEqualTo(String value) {
            addCriterion("customer_master_owner <=", value, "customerMasterOwner");
            return (Criteria) this;
        }

        public Criteria andCustomerMasterOwnerLike(String value) {
            addCriterion("customer_master_owner like", value, "customerMasterOwner");
            return (Criteria) this;
        }

        public Criteria andCustomerMasterOwnerNotLike(String value) {
            addCriterion("customer_master_owner not like", value, "customerMasterOwner");
            return (Criteria) this;
        }

        public Criteria andCustomerMasterOwnerIn(List<String> values) {
            addCriterion("customer_master_owner in", values, "customerMasterOwner");
            return (Criteria) this;
        }

        public Criteria andCustomerMasterOwnerNotIn(List<String> values) {
            addCriterion("customer_master_owner not in", values, "customerMasterOwner");
            return (Criteria) this;
        }

        public Criteria andCustomerMasterOwnerBetween(String value1, String value2) {
            addCriterion("customer_master_owner between", value1, value2, "customerMasterOwner");
            return (Criteria) this;
        }

        public Criteria andCustomerMasterOwnerNotBetween(String value1, String value2) {
            addCriterion("customer_master_owner not between", value1, value2, "customerMasterOwner");
            return (Criteria) this;
        }

        public Criteria andArrivalMoneyDateIsNull() {
            addCriterion("arrival_money_date is null");
            return (Criteria) this;
        }

        public Criteria andArrivalMoneyDateIsNotNull() {
            addCriterion("arrival_money_date is not null");
            return (Criteria) this;
        }

        public Criteria andArrivalMoneyDateEqualTo(String value) {
            addCriterion("arrival_money_date =", value, "arrivalMoneyDate");
            return (Criteria) this;
        }

        public Criteria andArrivalMoneyDateNotEqualTo(String value) {
            addCriterion("arrival_money_date <>", value, "arrivalMoneyDate");
            return (Criteria) this;
        }

        public Criteria andArrivalMoneyDateGreaterThan(String value) {
            addCriterion("arrival_money_date >", value, "arrivalMoneyDate");
            return (Criteria) this;
        }

        public Criteria andArrivalMoneyDateGreaterThanOrEqualTo(String value) {
            addCriterion("arrival_money_date >=", value, "arrivalMoneyDate");
            return (Criteria) this;
        }

        public Criteria andArrivalMoneyDateLessThan(String value) {
            addCriterion("arrival_money_date <", value, "arrivalMoneyDate");
            return (Criteria) this;
        }

        public Criteria andArrivalMoneyDateLessThanOrEqualTo(String value) {
            addCriterion("arrival_money_date <=", value, "arrivalMoneyDate");
            return (Criteria) this;
        }

        public Criteria andArrivalMoneyDateLike(String value) {
            addCriterion("arrival_money_date like", value, "arrivalMoneyDate");
            return (Criteria) this;
        }

        public Criteria andArrivalMoneyDateNotLike(String value) {
            addCriterion("arrival_money_date not like", value, "arrivalMoneyDate");
            return (Criteria) this;
        }

        public Criteria andArrivalMoneyDateIn(List<String> values) {
            addCriterion("arrival_money_date in", values, "arrivalMoneyDate");
            return (Criteria) this;
        }

        public Criteria andArrivalMoneyDateNotIn(List<String> values) {
            addCriterion("arrival_money_date not in", values, "arrivalMoneyDate");
            return (Criteria) this;
        }

        public Criteria andArrivalMoneyDateBetween(String value1, String value2) {
            addCriterion("arrival_money_date between", value1, value2, "arrivalMoneyDate");
            return (Criteria) this;
        }

        public Criteria andArrivalMoneyDateNotBetween(String value1, String value2) {
            addCriterion("arrival_money_date not between", value1, value2, "arrivalMoneyDate");
            return (Criteria) this;
        }

        public Criteria andIsItAllPaidIsNull() {
            addCriterion("is_it_all_paid is null");
            return (Criteria) this;
        }

        public Criteria andIsItAllPaidIsNotNull() {
            addCriterion("is_it_all_paid is not null");
            return (Criteria) this;
        }

        public Criteria andIsItAllPaidEqualTo(String value) {
            addCriterion("is_it_all_paid =", value, "isItAllPaid");
            return (Criteria) this;
        }

        public Criteria andIsItAllPaidNotEqualTo(String value) {
            addCriterion("is_it_all_paid <>", value, "isItAllPaid");
            return (Criteria) this;
        }

        public Criteria andIsItAllPaidGreaterThan(String value) {
            addCriterion("is_it_all_paid >", value, "isItAllPaid");
            return (Criteria) this;
        }

        public Criteria andIsItAllPaidGreaterThanOrEqualTo(String value) {
            addCriterion("is_it_all_paid >=", value, "isItAllPaid");
            return (Criteria) this;
        }

        public Criteria andIsItAllPaidLessThan(String value) {
            addCriterion("is_it_all_paid <", value, "isItAllPaid");
            return (Criteria) this;
        }

        public Criteria andIsItAllPaidLessThanOrEqualTo(String value) {
            addCriterion("is_it_all_paid <=", value, "isItAllPaid");
            return (Criteria) this;
        }

        public Criteria andIsItAllPaidLike(String value) {
            addCriterion("is_it_all_paid like", value, "isItAllPaid");
            return (Criteria) this;
        }

        public Criteria andIsItAllPaidNotLike(String value) {
            addCriterion("is_it_all_paid not like", value, "isItAllPaid");
            return (Criteria) this;
        }

        public Criteria andIsItAllPaidIn(List<String> values) {
            addCriterion("is_it_all_paid in", values, "isItAllPaid");
            return (Criteria) this;
        }

        public Criteria andIsItAllPaidNotIn(List<String> values) {
            addCriterion("is_it_all_paid not in", values, "isItAllPaid");
            return (Criteria) this;
        }

        public Criteria andIsItAllPaidBetween(String value1, String value2) {
            addCriterion("is_it_all_paid between", value1, value2, "isItAllPaid");
            return (Criteria) this;
        }

        public Criteria andIsItAllPaidNotBetween(String value1, String value2) {
            addCriterion("is_it_all_paid not between", value1, value2, "isItAllPaid");
            return (Criteria) this;
        }

        public Criteria andTotalAmountReturnedIsNull() {
            addCriterion("total_amount_returned is null");
            return (Criteria) this;
        }

        public Criteria andTotalAmountReturnedIsNotNull() {
            addCriterion("total_amount_returned is not null");
            return (Criteria) this;
        }

        public Criteria andTotalAmountReturnedEqualTo(String value) {
            addCriterion("total_amount_returned =", value, "totalAmountReturned");
            return (Criteria) this;
        }

        public Criteria andTotalAmountReturnedNotEqualTo(String value) {
            addCriterion("total_amount_returned <>", value, "totalAmountReturned");
            return (Criteria) this;
        }

        public Criteria andTotalAmountReturnedGreaterThan(String value) {
            addCriterion("total_amount_returned >", value, "totalAmountReturned");
            return (Criteria) this;
        }

        public Criteria andTotalAmountReturnedGreaterThanOrEqualTo(String value) {
            addCriterion("total_amount_returned >=", value, "totalAmountReturned");
            return (Criteria) this;
        }

        public Criteria andTotalAmountReturnedLessThan(String value) {
            addCriterion("total_amount_returned <", value, "totalAmountReturned");
            return (Criteria) this;
        }

        public Criteria andTotalAmountReturnedLessThanOrEqualTo(String value) {
            addCriterion("total_amount_returned <=", value, "totalAmountReturned");
            return (Criteria) this;
        }

        public Criteria andTotalAmountReturnedLike(String value) {
            addCriterion("total_amount_returned like", value, "totalAmountReturned");
            return (Criteria) this;
        }

        public Criteria andTotalAmountReturnedNotLike(String value) {
            addCriterion("total_amount_returned not like", value, "totalAmountReturned");
            return (Criteria) this;
        }

        public Criteria andTotalAmountReturnedIn(List<String> values) {
            addCriterion("total_amount_returned in", values, "totalAmountReturned");
            return (Criteria) this;
        }

        public Criteria andTotalAmountReturnedNotIn(List<String> values) {
            addCriterion("total_amount_returned not in", values, "totalAmountReturned");
            return (Criteria) this;
        }

        public Criteria andTotalAmountReturnedBetween(String value1, String value2) {
            addCriterion("total_amount_returned between", value1, value2, "totalAmountReturned");
            return (Criteria) this;
        }

        public Criteria andTotalAmountReturnedNotBetween(String value1, String value2) {
            addCriterion("total_amount_returned not between", value1, value2, "totalAmountReturned");
            return (Criteria) this;
        }

        public Criteria andRefundDateIsNull() {
            addCriterion("refund_date is null");
            return (Criteria) this;
        }

        public Criteria andRefundDateIsNotNull() {
            addCriterion("refund_date is not null");
            return (Criteria) this;
        }

        public Criteria andRefundDateEqualTo(String value) {
            addCriterion("refund_date =", value, "refundDate");
            return (Criteria) this;
        }

        public Criteria andRefundDateNotEqualTo(String value) {
            addCriterion("refund_date <>", value, "refundDate");
            return (Criteria) this;
        }

        public Criteria andRefundDateGreaterThan(String value) {
            addCriterion("refund_date >", value, "refundDate");
            return (Criteria) this;
        }

        public Criteria andRefundDateGreaterThanOrEqualTo(String value) {
            addCriterion("refund_date >=", value, "refundDate");
            return (Criteria) this;
        }

        public Criteria andRefundDateLessThan(String value) {
            addCriterion("refund_date <", value, "refundDate");
            return (Criteria) this;
        }

        public Criteria andRefundDateLessThanOrEqualTo(String value) {
            addCriterion("refund_date <=", value, "refundDate");
            return (Criteria) this;
        }

        public Criteria andRefundDateLike(String value) {
            addCriterion("refund_date like", value, "refundDate");
            return (Criteria) this;
        }

        public Criteria andRefundDateNotLike(String value) {
            addCriterion("refund_date not like", value, "refundDate");
            return (Criteria) this;
        }

        public Criteria andRefundDateIn(List<String> values) {
            addCriterion("refund_date in", values, "refundDate");
            return (Criteria) this;
        }

        public Criteria andRefundDateNotIn(List<String> values) {
            addCriterion("refund_date not in", values, "refundDate");
            return (Criteria) this;
        }

        public Criteria andRefundDateBetween(String value1, String value2) {
            addCriterion("refund_date between", value1, value2, "refundDate");
            return (Criteria) this;
        }

        public Criteria andRefundDateNotBetween(String value1, String value2) {
            addCriterion("refund_date not between", value1, value2, "refundDate");
            return (Criteria) this;
        }

        public Criteria andMembershipCardTypeIsNull() {
            addCriterion("membership_card_type is null");
            return (Criteria) this;
        }

        public Criteria andMembershipCardTypeIsNotNull() {
            addCriterion("membership_card_type is not null");
            return (Criteria) this;
        }

        public Criteria andMembershipCardTypeEqualTo(String value) {
            addCriterion("membership_card_type =", value, "membershipCardType");
            return (Criteria) this;
        }

        public Criteria andMembershipCardTypeNotEqualTo(String value) {
            addCriterion("membership_card_type <>", value, "membershipCardType");
            return (Criteria) this;
        }

        public Criteria andMembershipCardTypeGreaterThan(String value) {
            addCriterion("membership_card_type >", value, "membershipCardType");
            return (Criteria) this;
        }

        public Criteria andMembershipCardTypeGreaterThanOrEqualTo(String value) {
            addCriterion("membership_card_type >=", value, "membershipCardType");
            return (Criteria) this;
        }

        public Criteria andMembershipCardTypeLessThan(String value) {
            addCriterion("membership_card_type <", value, "membershipCardType");
            return (Criteria) this;
        }

        public Criteria andMembershipCardTypeLessThanOrEqualTo(String value) {
            addCriterion("membership_card_type <=", value, "membershipCardType");
            return (Criteria) this;
        }

        public Criteria andMembershipCardTypeLike(String value) {
            addCriterion("membership_card_type like", value, "membershipCardType");
            return (Criteria) this;
        }

        public Criteria andMembershipCardTypeNotLike(String value) {
            addCriterion("membership_card_type not like", value, "membershipCardType");
            return (Criteria) this;
        }

        public Criteria andMembershipCardTypeIn(List<String> values) {
            addCriterion("membership_card_type in", values, "membershipCardType");
            return (Criteria) this;
        }

        public Criteria andMembershipCardTypeNotIn(List<String> values) {
            addCriterion("membership_card_type not in", values, "membershipCardType");
            return (Criteria) this;
        }

        public Criteria andMembershipCardTypeBetween(String value1, String value2) {
            addCriterion("membership_card_type between", value1, value2, "membershipCardType");
            return (Criteria) this;
        }

        public Criteria andMembershipCardTypeNotBetween(String value1, String value2) {
            addCriterion("membership_card_type not between", value1, value2, "membershipCardType");
            return (Criteria) this;
        }

        public Criteria andCompanyNumberIsNull() {
            addCriterion("company_number is null");
            return (Criteria) this;
        }

        public Criteria andCompanyNumberIsNotNull() {
            addCriterion("company_number is not null");
            return (Criteria) this;
        }

        public Criteria andCompanyNumberEqualTo(String value) {
            addCriterion("company_number =", value, "companyNumber");
            return (Criteria) this;
        }

        public Criteria andCompanyNumberNotEqualTo(String value) {
            addCriterion("company_number <>", value, "companyNumber");
            return (Criteria) this;
        }

        public Criteria andCompanyNumberGreaterThan(String value) {
            addCriterion("company_number >", value, "companyNumber");
            return (Criteria) this;
        }

        public Criteria andCompanyNumberGreaterThanOrEqualTo(String value) {
            addCriterion("company_number >=", value, "companyNumber");
            return (Criteria) this;
        }

        public Criteria andCompanyNumberLessThan(String value) {
            addCriterion("company_number <", value, "companyNumber");
            return (Criteria) this;
        }

        public Criteria andCompanyNumberLessThanOrEqualTo(String value) {
            addCriterion("company_number <=", value, "companyNumber");
            return (Criteria) this;
        }

        public Criteria andCompanyNumberLike(String value) {
            addCriterion("company_number like", value, "companyNumber");
            return (Criteria) this;
        }

        public Criteria andCompanyNumberNotLike(String value) {
            addCriterion("company_number not like", value, "companyNumber");
            return (Criteria) this;
        }

        public Criteria andCompanyNumberIn(List<String> values) {
            addCriterion("company_number in", values, "companyNumber");
            return (Criteria) this;
        }

        public Criteria andCompanyNumberNotIn(List<String> values) {
            addCriterion("company_number not in", values, "companyNumber");
            return (Criteria) this;
        }

        public Criteria andCompanyNumberBetween(String value1, String value2) {
            addCriterion("company_number between", value1, value2, "companyNumber");
            return (Criteria) this;
        }

        public Criteria andCompanyNumberNotBetween(String value1, String value2) {
            addCriterion("company_number not between", value1, value2, "companyNumber");
            return (Criteria) this;
        }

        public Criteria andMembershipClassificationIsNull() {
            addCriterion("membership_classification is null");
            return (Criteria) this;
        }

        public Criteria andMembershipClassificationIsNotNull() {
            addCriterion("membership_classification is not null");
            return (Criteria) this;
        }

        public Criteria andMembershipClassificationEqualTo(String value) {
            addCriterion("membership_classification =", value, "membershipClassification");
            return (Criteria) this;
        }

        public Criteria andMembershipClassificationNotEqualTo(String value) {
            addCriterion("membership_classification <>", value, "membershipClassification");
            return (Criteria) this;
        }

        public Criteria andMembershipClassificationGreaterThan(String value) {
            addCriterion("membership_classification >", value, "membershipClassification");
            return (Criteria) this;
        }

        public Criteria andMembershipClassificationGreaterThanOrEqualTo(String value) {
            addCriterion("membership_classification >=", value, "membershipClassification");
            return (Criteria) this;
        }

        public Criteria andMembershipClassificationLessThan(String value) {
            addCriterion("membership_classification <", value, "membershipClassification");
            return (Criteria) this;
        }

        public Criteria andMembershipClassificationLessThanOrEqualTo(String value) {
            addCriterion("membership_classification <=", value, "membershipClassification");
            return (Criteria) this;
        }

        public Criteria andMembershipClassificationLike(String value) {
            addCriterion("membership_classification like", value, "membershipClassification");
            return (Criteria) this;
        }

        public Criteria andMembershipClassificationNotLike(String value) {
            addCriterion("membership_classification not like", value, "membershipClassification");
            return (Criteria) this;
        }

        public Criteria andMembershipClassificationIn(List<String> values) {
            addCriterion("membership_classification in", values, "membershipClassification");
            return (Criteria) this;
        }

        public Criteria andMembershipClassificationNotIn(List<String> values) {
            addCriterion("membership_classification not in", values, "membershipClassification");
            return (Criteria) this;
        }

        public Criteria andMembershipClassificationBetween(String value1, String value2) {
            addCriterion("membership_classification between", value1, value2, "membershipClassification");
            return (Criteria) this;
        }

        public Criteria andMembershipClassificationNotBetween(String value1, String value2) {
            addCriterion("membership_classification not between", value1, value2, "membershipClassification");
            return (Criteria) this;
        }

        public Criteria andMembershipCardNumberIsNull() {
            addCriterion("membership_card_number is null");
            return (Criteria) this;
        }

        public Criteria andMembershipCardNumberIsNotNull() {
            addCriterion("membership_card_number is not null");
            return (Criteria) this;
        }

        public Criteria andMembershipCardNumberEqualTo(String value) {
            addCriterion("membership_card_number =", value, "membershipCardNumber");
            return (Criteria) this;
        }

        public Criteria andMembershipCardNumberNotEqualTo(String value) {
            addCriterion("membership_card_number <>", value, "membershipCardNumber");
            return (Criteria) this;
        }

        public Criteria andMembershipCardNumberGreaterThan(String value) {
            addCriterion("membership_card_number >", value, "membershipCardNumber");
            return (Criteria) this;
        }

        public Criteria andMembershipCardNumberGreaterThanOrEqualTo(String value) {
            addCriterion("membership_card_number >=", value, "membershipCardNumber");
            return (Criteria) this;
        }

        public Criteria andMembershipCardNumberLessThan(String value) {
            addCriterion("membership_card_number <", value, "membershipCardNumber");
            return (Criteria) this;
        }

        public Criteria andMembershipCardNumberLessThanOrEqualTo(String value) {
            addCriterion("membership_card_number <=", value, "membershipCardNumber");
            return (Criteria) this;
        }

        public Criteria andMembershipCardNumberLike(String value) {
            addCriterion("membership_card_number like", value, "membershipCardNumber");
            return (Criteria) this;
        }

        public Criteria andMembershipCardNumberNotLike(String value) {
            addCriterion("membership_card_number not like", value, "membershipCardNumber");
            return (Criteria) this;
        }

        public Criteria andMembershipCardNumberIn(List<String> values) {
            addCriterion("membership_card_number in", values, "membershipCardNumber");
            return (Criteria) this;
        }

        public Criteria andMembershipCardNumberNotIn(List<String> values) {
            addCriterion("membership_card_number not in", values, "membershipCardNumber");
            return (Criteria) this;
        }

        public Criteria andMembershipCardNumberBetween(String value1, String value2) {
            addCriterion("membership_card_number between", value1, value2, "membershipCardNumber");
            return (Criteria) this;
        }

        public Criteria andMembershipCardNumberNotBetween(String value1, String value2) {
            addCriterion("membership_card_number not between", value1, value2, "membershipCardNumber");
            return (Criteria) this;
        }

        public Criteria andTaxLawThroughTrainCardNumberIsNull() {
            addCriterion("tax_law_through_train_card_number is null");
            return (Criteria) this;
        }

        public Criteria andTaxLawThroughTrainCardNumberIsNotNull() {
            addCriterion("tax_law_through_train_card_number is not null");
            return (Criteria) this;
        }

        public Criteria andTaxLawThroughTrainCardNumberEqualTo(String value) {
            addCriterion("tax_law_through_train_card_number =", value, "taxLawThroughTrainCardNumber");
            return (Criteria) this;
        }

        public Criteria andTaxLawThroughTrainCardNumberNotEqualTo(String value) {
            addCriterion("tax_law_through_train_card_number <>", value, "taxLawThroughTrainCardNumber");
            return (Criteria) this;
        }

        public Criteria andTaxLawThroughTrainCardNumberGreaterThan(String value) {
            addCriterion("tax_law_through_train_card_number >", value, "taxLawThroughTrainCardNumber");
            return (Criteria) this;
        }

        public Criteria andTaxLawThroughTrainCardNumberGreaterThanOrEqualTo(String value) {
            addCriterion("tax_law_through_train_card_number >=", value, "taxLawThroughTrainCardNumber");
            return (Criteria) this;
        }

        public Criteria andTaxLawThroughTrainCardNumberLessThan(String value) {
            addCriterion("tax_law_through_train_card_number <", value, "taxLawThroughTrainCardNumber");
            return (Criteria) this;
        }

        public Criteria andTaxLawThroughTrainCardNumberLessThanOrEqualTo(String value) {
            addCriterion("tax_law_through_train_card_number <=", value, "taxLawThroughTrainCardNumber");
            return (Criteria) this;
        }

        public Criteria andTaxLawThroughTrainCardNumberLike(String value) {
            addCriterion("tax_law_through_train_card_number like", value, "taxLawThroughTrainCardNumber");
            return (Criteria) this;
        }

        public Criteria andTaxLawThroughTrainCardNumberNotLike(String value) {
            addCriterion("tax_law_through_train_card_number not like", value, "taxLawThroughTrainCardNumber");
            return (Criteria) this;
        }

        public Criteria andTaxLawThroughTrainCardNumberIn(List<String> values) {
            addCriterion("tax_law_through_train_card_number in", values, "taxLawThroughTrainCardNumber");
            return (Criteria) this;
        }

        public Criteria andTaxLawThroughTrainCardNumberNotIn(List<String> values) {
            addCriterion("tax_law_through_train_card_number not in", values, "taxLawThroughTrainCardNumber");
            return (Criteria) this;
        }

        public Criteria andTaxLawThroughTrainCardNumberBetween(String value1, String value2) {
            addCriterion("tax_law_through_train_card_number between", value1, value2, "taxLawThroughTrainCardNumber");
            return (Criteria) this;
        }

        public Criteria andTaxLawThroughTrainCardNumberNotBetween(String value1, String value2) {
            addCriterion("tax_law_through_train_card_number not between", value1, value2, "taxLawThroughTrainCardNumber");
            return (Criteria) this;
        }

        public Criteria andCooperativeDevelopmentOrNotIsNull() {
            addCriterion("cooperative_development_or_not is null");
            return (Criteria) this;
        }

        public Criteria andCooperativeDevelopmentOrNotIsNotNull() {
            addCriterion("cooperative_development_or_not is not null");
            return (Criteria) this;
        }

        public Criteria andCooperativeDevelopmentOrNotEqualTo(String value) {
            addCriterion("cooperative_development_or_not =", value, "cooperativeDevelopmentOrNot");
            return (Criteria) this;
        }

        public Criteria andCooperativeDevelopmentOrNotNotEqualTo(String value) {
            addCriterion("cooperative_development_or_not <>", value, "cooperativeDevelopmentOrNot");
            return (Criteria) this;
        }

        public Criteria andCooperativeDevelopmentOrNotGreaterThan(String value) {
            addCriterion("cooperative_development_or_not >", value, "cooperativeDevelopmentOrNot");
            return (Criteria) this;
        }

        public Criteria andCooperativeDevelopmentOrNotGreaterThanOrEqualTo(String value) {
            addCriterion("cooperative_development_or_not >=", value, "cooperativeDevelopmentOrNot");
            return (Criteria) this;
        }

        public Criteria andCooperativeDevelopmentOrNotLessThan(String value) {
            addCriterion("cooperative_development_or_not <", value, "cooperativeDevelopmentOrNot");
            return (Criteria) this;
        }

        public Criteria andCooperativeDevelopmentOrNotLessThanOrEqualTo(String value) {
            addCriterion("cooperative_development_or_not <=", value, "cooperativeDevelopmentOrNot");
            return (Criteria) this;
        }

        public Criteria andCooperativeDevelopmentOrNotLike(String value) {
            addCriterion("cooperative_development_or_not like", value, "cooperativeDevelopmentOrNot");
            return (Criteria) this;
        }

        public Criteria andCooperativeDevelopmentOrNotNotLike(String value) {
            addCriterion("cooperative_development_or_not not like", value, "cooperativeDevelopmentOrNot");
            return (Criteria) this;
        }

        public Criteria andCooperativeDevelopmentOrNotIn(List<String> values) {
            addCriterion("cooperative_development_or_not in", values, "cooperativeDevelopmentOrNot");
            return (Criteria) this;
        }

        public Criteria andCooperativeDevelopmentOrNotNotIn(List<String> values) {
            addCriterion("cooperative_development_or_not not in", values, "cooperativeDevelopmentOrNot");
            return (Criteria) this;
        }

        public Criteria andCooperativeDevelopmentOrNotBetween(String value1, String value2) {
            addCriterion("cooperative_development_or_not between", value1, value2, "cooperativeDevelopmentOrNot");
            return (Criteria) this;
        }

        public Criteria andCooperativeDevelopmentOrNotNotBetween(String value1, String value2) {
            addCriterion("cooperative_development_or_not not between", value1, value2, "cooperativeDevelopmentOrNot");
            return (Criteria) this;
        }

        public Criteria andCooperativeDeveloperIsNull() {
            addCriterion("cooperative_developer is null");
            return (Criteria) this;
        }

        public Criteria andCooperativeDeveloperIsNotNull() {
            addCriterion("cooperative_developer is not null");
            return (Criteria) this;
        }

        public Criteria andCooperativeDeveloperEqualTo(String value) {
            addCriterion("cooperative_developer =", value, "cooperativeDeveloper");
            return (Criteria) this;
        }

        public Criteria andCooperativeDeveloperNotEqualTo(String value) {
            addCriterion("cooperative_developer <>", value, "cooperativeDeveloper");
            return (Criteria) this;
        }

        public Criteria andCooperativeDeveloperGreaterThan(String value) {
            addCriterion("cooperative_developer >", value, "cooperativeDeveloper");
            return (Criteria) this;
        }

        public Criteria andCooperativeDeveloperGreaterThanOrEqualTo(String value) {
            addCriterion("cooperative_developer >=", value, "cooperativeDeveloper");
            return (Criteria) this;
        }

        public Criteria andCooperativeDeveloperLessThan(String value) {
            addCriterion("cooperative_developer <", value, "cooperativeDeveloper");
            return (Criteria) this;
        }

        public Criteria andCooperativeDeveloperLessThanOrEqualTo(String value) {
            addCriterion("cooperative_developer <=", value, "cooperativeDeveloper");
            return (Criteria) this;
        }

        public Criteria andCooperativeDeveloperLike(String value) {
            addCriterion("cooperative_developer like", value, "cooperativeDeveloper");
            return (Criteria) this;
        }

        public Criteria andCooperativeDeveloperNotLike(String value) {
            addCriterion("cooperative_developer not like", value, "cooperativeDeveloper");
            return (Criteria) this;
        }

        public Criteria andCooperativeDeveloperIn(List<String> values) {
            addCriterion("cooperative_developer in", values, "cooperativeDeveloper");
            return (Criteria) this;
        }

        public Criteria andCooperativeDeveloperNotIn(List<String> values) {
            addCriterion("cooperative_developer not in", values, "cooperativeDeveloper");
            return (Criteria) this;
        }

        public Criteria andCooperativeDeveloperBetween(String value1, String value2) {
            addCriterion("cooperative_developer between", value1, value2, "cooperativeDeveloper");
            return (Criteria) this;
        }

        public Criteria andCooperativeDeveloperNotBetween(String value1, String value2) {
            addCriterion("cooperative_developer not between", value1, value2, "cooperativeDeveloper");
            return (Criteria) this;
        }

        public Criteria andOriginalCustomerIdIsNull() {
            addCriterion("original_customer_id is null");
            return (Criteria) this;
        }

        public Criteria andOriginalCustomerIdIsNotNull() {
            addCriterion("original_customer_id is not null");
            return (Criteria) this;
        }

        public Criteria andOriginalCustomerIdEqualTo(String value) {
            addCriterion("original_customer_id =", value, "originalCustomerId");
            return (Criteria) this;
        }

        public Criteria andOriginalCustomerIdNotEqualTo(String value) {
            addCriterion("original_customer_id <>", value, "originalCustomerId");
            return (Criteria) this;
        }

        public Criteria andOriginalCustomerIdGreaterThan(String value) {
            addCriterion("original_customer_id >", value, "originalCustomerId");
            return (Criteria) this;
        }

        public Criteria andOriginalCustomerIdGreaterThanOrEqualTo(String value) {
            addCriterion("original_customer_id >=", value, "originalCustomerId");
            return (Criteria) this;
        }

        public Criteria andOriginalCustomerIdLessThan(String value) {
            addCriterion("original_customer_id <", value, "originalCustomerId");
            return (Criteria) this;
        }

        public Criteria andOriginalCustomerIdLessThanOrEqualTo(String value) {
            addCriterion("original_customer_id <=", value, "originalCustomerId");
            return (Criteria) this;
        }

        public Criteria andOriginalCustomerIdLike(String value) {
            addCriterion("original_customer_id like", value, "originalCustomerId");
            return (Criteria) this;
        }

        public Criteria andOriginalCustomerIdNotLike(String value) {
            addCriterion("original_customer_id not like", value, "originalCustomerId");
            return (Criteria) this;
        }

        public Criteria andOriginalCustomerIdIn(List<String> values) {
            addCriterion("original_customer_id in", values, "originalCustomerId");
            return (Criteria) this;
        }

        public Criteria andOriginalCustomerIdNotIn(List<String> values) {
            addCriterion("original_customer_id not in", values, "originalCustomerId");
            return (Criteria) this;
        }

        public Criteria andOriginalCustomerIdBetween(String value1, String value2) {
            addCriterion("original_customer_id between", value1, value2, "originalCustomerId");
            return (Criteria) this;
        }

        public Criteria andOriginalCustomerIdNotBetween(String value1, String value2) {
            addCriterion("original_customer_id not between", value1, value2, "originalCustomerId");
            return (Criteria) this;
        }

        public Criteria andWhetherToDeleteOrNotIsNull() {
            addCriterion("whether_to_delete_or_not is null");
            return (Criteria) this;
        }

        public Criteria andWhetherToDeleteOrNotIsNotNull() {
            addCriterion("whether_to_delete_or_not is not null");
            return (Criteria) this;
        }

        public Criteria andWhetherToDeleteOrNotEqualTo(String value) {
            addCriterion("whether_to_delete_or_not =", value, "whetherToDeleteOrNot");
            return (Criteria) this;
        }

        public Criteria andWhetherToDeleteOrNotNotEqualTo(String value) {
            addCriterion("whether_to_delete_or_not <>", value, "whetherToDeleteOrNot");
            return (Criteria) this;
        }

        public Criteria andWhetherToDeleteOrNotGreaterThan(String value) {
            addCriterion("whether_to_delete_or_not >", value, "whetherToDeleteOrNot");
            return (Criteria) this;
        }

        public Criteria andWhetherToDeleteOrNotGreaterThanOrEqualTo(String value) {
            addCriterion("whether_to_delete_or_not >=", value, "whetherToDeleteOrNot");
            return (Criteria) this;
        }

        public Criteria andWhetherToDeleteOrNotLessThan(String value) {
            addCriterion("whether_to_delete_or_not <", value, "whetherToDeleteOrNot");
            return (Criteria) this;
        }

        public Criteria andWhetherToDeleteOrNotLessThanOrEqualTo(String value) {
            addCriterion("whether_to_delete_or_not <=", value, "whetherToDeleteOrNot");
            return (Criteria) this;
        }

        public Criteria andWhetherToDeleteOrNotLike(String value) {
            addCriterion("whether_to_delete_or_not like", value, "whetherToDeleteOrNot");
            return (Criteria) this;
        }

        public Criteria andWhetherToDeleteOrNotNotLike(String value) {
            addCriterion("whether_to_delete_or_not not like", value, "whetherToDeleteOrNot");
            return (Criteria) this;
        }

        public Criteria andWhetherToDeleteOrNotIn(List<String> values) {
            addCriterion("whether_to_delete_or_not in", values, "whetherToDeleteOrNot");
            return (Criteria) this;
        }

        public Criteria andWhetherToDeleteOrNotNotIn(List<String> values) {
            addCriterion("whether_to_delete_or_not not in", values, "whetherToDeleteOrNot");
            return (Criteria) this;
        }

        public Criteria andWhetherToDeleteOrNotBetween(String value1, String value2) {
            addCriterion("whether_to_delete_or_not between", value1, value2, "whetherToDeleteOrNot");
            return (Criteria) this;
        }

        public Criteria andWhetherToDeleteOrNotNotBetween(String value1, String value2) {
            addCriterion("whether_to_delete_or_not not between", value1, value2, "whetherToDeleteOrNot");
            return (Criteria) this;
        }

        public Criteria andAttachmentIsNull() {
            addCriterion("attachment is null");
            return (Criteria) this;
        }

        public Criteria andAttachmentIsNotNull() {
            addCriterion("attachment is not null");
            return (Criteria) this;
        }

        public Criteria andAttachmentEqualTo(String value) {
            addCriterion("attachment =", value, "attachment");
            return (Criteria) this;
        }

        public Criteria andAttachmentNotEqualTo(String value) {
            addCriterion("attachment <>", value, "attachment");
            return (Criteria) this;
        }

        public Criteria andAttachmentGreaterThan(String value) {
            addCriterion("attachment >", value, "attachment");
            return (Criteria) this;
        }

        public Criteria andAttachmentGreaterThanOrEqualTo(String value) {
            addCriterion("attachment >=", value, "attachment");
            return (Criteria) this;
        }

        public Criteria andAttachmentLessThan(String value) {
            addCriterion("attachment <", value, "attachment");
            return (Criteria) this;
        }

        public Criteria andAttachmentLessThanOrEqualTo(String value) {
            addCriterion("attachment <=", value, "attachment");
            return (Criteria) this;
        }

        public Criteria andAttachmentLike(String value) {
            addCriterion("attachment like", value, "attachment");
            return (Criteria) this;
        }

        public Criteria andAttachmentNotLike(String value) {
            addCriterion("attachment not like", value, "attachment");
            return (Criteria) this;
        }

        public Criteria andAttachmentIn(List<String> values) {
            addCriterion("attachment in", values, "attachment");
            return (Criteria) this;
        }

        public Criteria andAttachmentNotIn(List<String> values) {
            addCriterion("attachment not in", values, "attachment");
            return (Criteria) this;
        }

        public Criteria andAttachmentBetween(String value1, String value2) {
            addCriterion("attachment between", value1, value2, "attachment");
            return (Criteria) this;
        }

        public Criteria andAttachmentNotBetween(String value1, String value2) {
            addCriterion("attachment not between", value1, value2, "attachment");
            return (Criteria) this;
        }

        public Criteria andClueClassificationIsNull() {
            addCriterion("clue_classification is null");
            return (Criteria) this;
        }

        public Criteria andClueClassificationIsNotNull() {
            addCriterion("clue_classification is not null");
            return (Criteria) this;
        }

        public Criteria andClueClassificationEqualTo(String value) {
            addCriterion("clue_classification =", value, "clueClassification");
            return (Criteria) this;
        }

        public Criteria andClueClassificationNotEqualTo(String value) {
            addCriterion("clue_classification <>", value, "clueClassification");
            return (Criteria) this;
        }

        public Criteria andClueClassificationGreaterThan(String value) {
            addCriterion("clue_classification >", value, "clueClassification");
            return (Criteria) this;
        }

        public Criteria andClueClassificationGreaterThanOrEqualTo(String value) {
            addCriterion("clue_classification >=", value, "clueClassification");
            return (Criteria) this;
        }

        public Criteria andClueClassificationLessThan(String value) {
            addCriterion("clue_classification <", value, "clueClassification");
            return (Criteria) this;
        }

        public Criteria andClueClassificationLessThanOrEqualTo(String value) {
            addCriterion("clue_classification <=", value, "clueClassification");
            return (Criteria) this;
        }

        public Criteria andClueClassificationLike(String value) {
            addCriterion("clue_classification like", value, "clueClassification");
            return (Criteria) this;
        }

        public Criteria andClueClassificationNotLike(String value) {
            addCriterion("clue_classification not like", value, "clueClassification");
            return (Criteria) this;
        }

        public Criteria andClueClassificationIn(List<String> values) {
            addCriterion("clue_classification in", values, "clueClassification");
            return (Criteria) this;
        }

        public Criteria andClueClassificationNotIn(List<String> values) {
            addCriterion("clue_classification not in", values, "clueClassification");
            return (Criteria) this;
        }

        public Criteria andClueClassificationBetween(String value1, String value2) {
            addCriterion("clue_classification between", value1, value2, "clueClassification");
            return (Criteria) this;
        }

        public Criteria andClueClassificationNotBetween(String value1, String value2) {
            addCriterion("clue_classification not between", value1, value2, "clueClassification");
            return (Criteria) this;
        }

        public Criteria andWhetherTheInspectionIsNull() {
            addCriterion("whether_the_inspection is null");
            return (Criteria) this;
        }

        public Criteria andWhetherTheInspectionIsNotNull() {
            addCriterion("whether_the_inspection is not null");
            return (Criteria) this;
        }

        public Criteria andWhetherTheInspectionEqualTo(String value) {
            addCriterion("whether_the_inspection =", value, "whetherTheInspection");
            return (Criteria) this;
        }

        public Criteria andWhetherTheInspectionNotEqualTo(String value) {
            addCriterion("whether_the_inspection <>", value, "whetherTheInspection");
            return (Criteria) this;
        }

        public Criteria andWhetherTheInspectionGreaterThan(String value) {
            addCriterion("whether_the_inspection >", value, "whetherTheInspection");
            return (Criteria) this;
        }

        public Criteria andWhetherTheInspectionGreaterThanOrEqualTo(String value) {
            addCriterion("whether_the_inspection >=", value, "whetherTheInspection");
            return (Criteria) this;
        }

        public Criteria andWhetherTheInspectionLessThan(String value) {
            addCriterion("whether_the_inspection <", value, "whetherTheInspection");
            return (Criteria) this;
        }

        public Criteria andWhetherTheInspectionLessThanOrEqualTo(String value) {
            addCriterion("whether_the_inspection <=", value, "whetherTheInspection");
            return (Criteria) this;
        }

        public Criteria andWhetherTheInspectionLike(String value) {
            addCriterion("whether_the_inspection like", value, "whetherTheInspection");
            return (Criteria) this;
        }

        public Criteria andWhetherTheInspectionNotLike(String value) {
            addCriterion("whether_the_inspection not like", value, "whetherTheInspection");
            return (Criteria) this;
        }

        public Criteria andWhetherTheInspectionIn(List<String> values) {
            addCriterion("whether_the_inspection in", values, "whetherTheInspection");
            return (Criteria) this;
        }

        public Criteria andWhetherTheInspectionNotIn(List<String> values) {
            addCriterion("whether_the_inspection not in", values, "whetherTheInspection");
            return (Criteria) this;
        }

        public Criteria andWhetherTheInspectionBetween(String value1, String value2) {
            addCriterion("whether_the_inspection between", value1, value2, "whetherTheInspection");
            return (Criteria) this;
        }

        public Criteria andWhetherTheInspectionNotBetween(String value1, String value2) {
            addCriterion("whether_the_inspection not between", value1, value2, "whetherTheInspection");
            return (Criteria) this;
        }

        public Criteria andMailboxIsNull() {
            addCriterion("mailbox is null");
            return (Criteria) this;
        }

        public Criteria andMailboxIsNotNull() {
            addCriterion("mailbox is not null");
            return (Criteria) this;
        }

        public Criteria andMailboxEqualTo(String value) {
            addCriterion("mailbox =", value, "mailbox");
            return (Criteria) this;
        }

        public Criteria andMailboxNotEqualTo(String value) {
            addCriterion("mailbox <>", value, "mailbox");
            return (Criteria) this;
        }

        public Criteria andMailboxGreaterThan(String value) {
            addCriterion("mailbox >", value, "mailbox");
            return (Criteria) this;
        }

        public Criteria andMailboxGreaterThanOrEqualTo(String value) {
            addCriterion("mailbox >=", value, "mailbox");
            return (Criteria) this;
        }

        public Criteria andMailboxLessThan(String value) {
            addCriterion("mailbox <", value, "mailbox");
            return (Criteria) this;
        }

        public Criteria andMailboxLessThanOrEqualTo(String value) {
            addCriterion("mailbox <=", value, "mailbox");
            return (Criteria) this;
        }

        public Criteria andMailboxLike(String value) {
            addCriterion("mailbox like", value, "mailbox");
            return (Criteria) this;
        }

        public Criteria andMailboxNotLike(String value) {
            addCriterion("mailbox not like", value, "mailbox");
            return (Criteria) this;
        }

        public Criteria andMailboxIn(List<String> values) {
            addCriterion("mailbox in", values, "mailbox");
            return (Criteria) this;
        }

        public Criteria andMailboxNotIn(List<String> values) {
            addCriterion("mailbox not in", values, "mailbox");
            return (Criteria) this;
        }

        public Criteria andMailboxBetween(String value1, String value2) {
            addCriterion("mailbox between", value1, value2, "mailbox");
            return (Criteria) this;
        }

        public Criteria andMailboxNotBetween(String value1, String value2) {
            addCriterion("mailbox not between", value1, value2, "mailbox");
            return (Criteria) this;
        }

        public Criteria andConsumptionTimesIsNull() {
            addCriterion("consumption_times is null");
            return (Criteria) this;
        }

        public Criteria andConsumptionTimesIsNotNull() {
            addCriterion("consumption_times is not null");
            return (Criteria) this;
        }

        public Criteria andConsumptionTimesEqualTo(String value) {
            addCriterion("consumption_times =", value, "consumptionTimes");
            return (Criteria) this;
        }

        public Criteria andConsumptionTimesNotEqualTo(String value) {
            addCriterion("consumption_times <>", value, "consumptionTimes");
            return (Criteria) this;
        }

        public Criteria andConsumptionTimesGreaterThan(String value) {
            addCriterion("consumption_times >", value, "consumptionTimes");
            return (Criteria) this;
        }

        public Criteria andConsumptionTimesGreaterThanOrEqualTo(String value) {
            addCriterion("consumption_times >=", value, "consumptionTimes");
            return (Criteria) this;
        }

        public Criteria andConsumptionTimesLessThan(String value) {
            addCriterion("consumption_times <", value, "consumptionTimes");
            return (Criteria) this;
        }

        public Criteria andConsumptionTimesLessThanOrEqualTo(String value) {
            addCriterion("consumption_times <=", value, "consumptionTimes");
            return (Criteria) this;
        }

        public Criteria andConsumptionTimesLike(String value) {
            addCriterion("consumption_times like", value, "consumptionTimes");
            return (Criteria) this;
        }

        public Criteria andConsumptionTimesNotLike(String value) {
            addCriterion("consumption_times not like", value, "consumptionTimes");
            return (Criteria) this;
        }

        public Criteria andConsumptionTimesIn(List<String> values) {
            addCriterion("consumption_times in", values, "consumptionTimes");
            return (Criteria) this;
        }

        public Criteria andConsumptionTimesNotIn(List<String> values) {
            addCriterion("consumption_times not in", values, "consumptionTimes");
            return (Criteria) this;
        }

        public Criteria andConsumptionTimesBetween(String value1, String value2) {
            addCriterion("consumption_times between", value1, value2, "consumptionTimes");
            return (Criteria) this;
        }

        public Criteria andConsumptionTimesNotBetween(String value1, String value2) {
            addCriterion("consumption_times not between", value1, value2, "consumptionTimes");
            return (Criteria) this;
        }

        public Criteria andConsumptionStatusIsNull() {
            addCriterion("consumption_status is null");
            return (Criteria) this;
        }

        public Criteria andConsumptionStatusIsNotNull() {
            addCriterion("consumption_status is not null");
            return (Criteria) this;
        }

        public Criteria andConsumptionStatusEqualTo(String value) {
            addCriterion("consumption_status =", value, "consumptionStatus");
            return (Criteria) this;
        }

        public Criteria andConsumptionStatusNotEqualTo(String value) {
            addCriterion("consumption_status <>", value, "consumptionStatus");
            return (Criteria) this;
        }

        public Criteria andConsumptionStatusGreaterThan(String value) {
            addCriterion("consumption_status >", value, "consumptionStatus");
            return (Criteria) this;
        }

        public Criteria andConsumptionStatusGreaterThanOrEqualTo(String value) {
            addCriterion("consumption_status >=", value, "consumptionStatus");
            return (Criteria) this;
        }

        public Criteria andConsumptionStatusLessThan(String value) {
            addCriterion("consumption_status <", value, "consumptionStatus");
            return (Criteria) this;
        }

        public Criteria andConsumptionStatusLessThanOrEqualTo(String value) {
            addCriterion("consumption_status <=", value, "consumptionStatus");
            return (Criteria) this;
        }

        public Criteria andConsumptionStatusLike(String value) {
            addCriterion("consumption_status like", value, "consumptionStatus");
            return (Criteria) this;
        }

        public Criteria andConsumptionStatusNotLike(String value) {
            addCriterion("consumption_status not like", value, "consumptionStatus");
            return (Criteria) this;
        }

        public Criteria andConsumptionStatusIn(List<String> values) {
            addCriterion("consumption_status in", values, "consumptionStatus");
            return (Criteria) this;
        }

        public Criteria andConsumptionStatusNotIn(List<String> values) {
            addCriterion("consumption_status not in", values, "consumptionStatus");
            return (Criteria) this;
        }

        public Criteria andConsumptionStatusBetween(String value1, String value2) {
            addCriterion("consumption_status between", value1, value2, "consumptionStatus");
            return (Criteria) this;
        }

        public Criteria andConsumptionStatusNotBetween(String value1, String value2) {
            addCriterion("consumption_status not between", value1, value2, "consumptionStatus");
            return (Criteria) this;
        }

        public Criteria andAdjustmentRecordIsNull() {
            addCriterion("adjustment_record is null");
            return (Criteria) this;
        }

        public Criteria andAdjustmentRecordIsNotNull() {
            addCriterion("adjustment_record is not null");
            return (Criteria) this;
        }

        public Criteria andAdjustmentRecordEqualTo(String value) {
            addCriterion("adjustment_record =", value, "adjustmentRecord");
            return (Criteria) this;
        }

        public Criteria andAdjustmentRecordNotEqualTo(String value) {
            addCriterion("adjustment_record <>", value, "adjustmentRecord");
            return (Criteria) this;
        }

        public Criteria andAdjustmentRecordGreaterThan(String value) {
            addCriterion("adjustment_record >", value, "adjustmentRecord");
            return (Criteria) this;
        }

        public Criteria andAdjustmentRecordGreaterThanOrEqualTo(String value) {
            addCriterion("adjustment_record >=", value, "adjustmentRecord");
            return (Criteria) this;
        }

        public Criteria andAdjustmentRecordLessThan(String value) {
            addCriterion("adjustment_record <", value, "adjustmentRecord");
            return (Criteria) this;
        }

        public Criteria andAdjustmentRecordLessThanOrEqualTo(String value) {
            addCriterion("adjustment_record <=", value, "adjustmentRecord");
            return (Criteria) this;
        }

        public Criteria andAdjustmentRecordLike(String value) {
            addCriterion("adjustment_record like", value, "adjustmentRecord");
            return (Criteria) this;
        }

        public Criteria andAdjustmentRecordNotLike(String value) {
            addCriterion("adjustment_record not like", value, "adjustmentRecord");
            return (Criteria) this;
        }

        public Criteria andAdjustmentRecordIn(List<String> values) {
            addCriterion("adjustment_record in", values, "adjustmentRecord");
            return (Criteria) this;
        }

        public Criteria andAdjustmentRecordNotIn(List<String> values) {
            addCriterion("adjustment_record not in", values, "adjustmentRecord");
            return (Criteria) this;
        }

        public Criteria andAdjustmentRecordBetween(String value1, String value2) {
            addCriterion("adjustment_record between", value1, value2, "adjustmentRecord");
            return (Criteria) this;
        }

        public Criteria andAdjustmentRecordNotBetween(String value1, String value2) {
            addCriterion("adjustment_record not between", value1, value2, "adjustmentRecord");
            return (Criteria) this;
        }

        public Criteria andCommissionDistributionStatusIsNull() {
            addCriterion("commission_distribution_status is null");
            return (Criteria) this;
        }

        public Criteria andCommissionDistributionStatusIsNotNull() {
            addCriterion("commission_distribution_status is not null");
            return (Criteria) this;
        }

        public Criteria andCommissionDistributionStatusEqualTo(String value) {
            addCriterion("commission_distribution_status =", value, "commissionDistributionStatus");
            return (Criteria) this;
        }

        public Criteria andCommissionDistributionStatusNotEqualTo(String value) {
            addCriterion("commission_distribution_status <>", value, "commissionDistributionStatus");
            return (Criteria) this;
        }

        public Criteria andCommissionDistributionStatusGreaterThan(String value) {
            addCriterion("commission_distribution_status >", value, "commissionDistributionStatus");
            return (Criteria) this;
        }

        public Criteria andCommissionDistributionStatusGreaterThanOrEqualTo(String value) {
            addCriterion("commission_distribution_status >=", value, "commissionDistributionStatus");
            return (Criteria) this;
        }

        public Criteria andCommissionDistributionStatusLessThan(String value) {
            addCriterion("commission_distribution_status <", value, "commissionDistributionStatus");
            return (Criteria) this;
        }

        public Criteria andCommissionDistributionStatusLessThanOrEqualTo(String value) {
            addCriterion("commission_distribution_status <=", value, "commissionDistributionStatus");
            return (Criteria) this;
        }

        public Criteria andCommissionDistributionStatusLike(String value) {
            addCriterion("commission_distribution_status like", value, "commissionDistributionStatus");
            return (Criteria) this;
        }

        public Criteria andCommissionDistributionStatusNotLike(String value) {
            addCriterion("commission_distribution_status not like", value, "commissionDistributionStatus");
            return (Criteria) this;
        }

        public Criteria andCommissionDistributionStatusIn(List<String> values) {
            addCriterion("commission_distribution_status in", values, "commissionDistributionStatus");
            return (Criteria) this;
        }

        public Criteria andCommissionDistributionStatusNotIn(List<String> values) {
            addCriterion("commission_distribution_status not in", values, "commissionDistributionStatus");
            return (Criteria) this;
        }

        public Criteria andCommissionDistributionStatusBetween(String value1, String value2) {
            addCriterion("commission_distribution_status between", value1, value2, "commissionDistributionStatus");
            return (Criteria) this;
        }

        public Criteria andCommissionDistributionStatusNotBetween(String value1, String value2) {
            addCriterion("commission_distribution_status not between", value1, value2, "commissionDistributionStatus");
            return (Criteria) this;
        }

        public Criteria andBranchGeneralManagerIsNull() {
            addCriterion("branch_general_manager is null");
            return (Criteria) this;
        }

        public Criteria andBranchGeneralManagerIsNotNull() {
            addCriterion("branch_general_manager is not null");
            return (Criteria) this;
        }

        public Criteria andBranchGeneralManagerEqualTo(String value) {
            addCriterion("branch_general_manager =", value, "branchGeneralManager");
            return (Criteria) this;
        }

        public Criteria andBranchGeneralManagerNotEqualTo(String value) {
            addCriterion("branch_general_manager <>", value, "branchGeneralManager");
            return (Criteria) this;
        }

        public Criteria andBranchGeneralManagerGreaterThan(String value) {
            addCriterion("branch_general_manager >", value, "branchGeneralManager");
            return (Criteria) this;
        }

        public Criteria andBranchGeneralManagerGreaterThanOrEqualTo(String value) {
            addCriterion("branch_general_manager >=", value, "branchGeneralManager");
            return (Criteria) this;
        }

        public Criteria andBranchGeneralManagerLessThan(String value) {
            addCriterion("branch_general_manager <", value, "branchGeneralManager");
            return (Criteria) this;
        }

        public Criteria andBranchGeneralManagerLessThanOrEqualTo(String value) {
            addCriterion("branch_general_manager <=", value, "branchGeneralManager");
            return (Criteria) this;
        }

        public Criteria andBranchGeneralManagerLike(String value) {
            addCriterion("branch_general_manager like", value, "branchGeneralManager");
            return (Criteria) this;
        }

        public Criteria andBranchGeneralManagerNotLike(String value) {
            addCriterion("branch_general_manager not like", value, "branchGeneralManager");
            return (Criteria) this;
        }

        public Criteria andBranchGeneralManagerIn(List<String> values) {
            addCriterion("branch_general_manager in", values, "branchGeneralManager");
            return (Criteria) this;
        }

        public Criteria andBranchGeneralManagerNotIn(List<String> values) {
            addCriterion("branch_general_manager not in", values, "branchGeneralManager");
            return (Criteria) this;
        }

        public Criteria andBranchGeneralManagerBetween(String value1, String value2) {
            addCriterion("branch_general_manager between", value1, value2, "branchGeneralManager");
            return (Criteria) this;
        }

        public Criteria andBranchGeneralManagerNotBetween(String value1, String value2) {
            addCriterion("branch_general_manager not between", value1, value2, "branchGeneralManager");
            return (Criteria) this;
        }

        public Criteria andOrderUpdateTimeIsNull() {
            addCriterion("order_update_time is null");
            return (Criteria) this;
        }

        public Criteria andOrderUpdateTimeIsNotNull() {
            addCriterion("order_update_time is not null");
            return (Criteria) this;
        }

        public Criteria andOrderUpdateTimeEqualTo(String value) {
            addCriterion("order_update_time =", value, "orderUpdateTime");
            return (Criteria) this;
        }

        public Criteria andOrderUpdateTimeNotEqualTo(String value) {
            addCriterion("order_update_time <>", value, "orderUpdateTime");
            return (Criteria) this;
        }

        public Criteria andOrderUpdateTimeGreaterThan(String value) {
            addCriterion("order_update_time >", value, "orderUpdateTime");
            return (Criteria) this;
        }

        public Criteria andOrderUpdateTimeGreaterThanOrEqualTo(String value) {
            addCriterion("order_update_time >=", value, "orderUpdateTime");
            return (Criteria) this;
        }

        public Criteria andOrderUpdateTimeLessThan(String value) {
            addCriterion("order_update_time <", value, "orderUpdateTime");
            return (Criteria) this;
        }

        public Criteria andOrderUpdateTimeLessThanOrEqualTo(String value) {
            addCriterion("order_update_time <=", value, "orderUpdateTime");
            return (Criteria) this;
        }

        public Criteria andOrderUpdateTimeLike(String value) {
            addCriterion("order_update_time like", value, "orderUpdateTime");
            return (Criteria) this;
        }

        public Criteria andOrderUpdateTimeNotLike(String value) {
            addCriterion("order_update_time not like", value, "orderUpdateTime");
            return (Criteria) this;
        }

        public Criteria andOrderUpdateTimeIn(List<String> values) {
            addCriterion("order_update_time in", values, "orderUpdateTime");
            return (Criteria) this;
        }

        public Criteria andOrderUpdateTimeNotIn(List<String> values) {
            addCriterion("order_update_time not in", values, "orderUpdateTime");
            return (Criteria) this;
        }

        public Criteria andOrderUpdateTimeBetween(String value1, String value2) {
            addCriterion("order_update_time between", value1, value2, "orderUpdateTime");
            return (Criteria) this;
        }

        public Criteria andOrderUpdateTimeNotBetween(String value1, String value2) {
            addCriterion("order_update_time not between", value1, value2, "orderUpdateTime");
            return (Criteria) this;
        }

        public Criteria andOrderCreatePeopleIsNull() {
            addCriterion("order_create_people is null");
            return (Criteria) this;
        }

        public Criteria andOrderCreatePeopleIsNotNull() {
            addCriterion("order_create_people is not null");
            return (Criteria) this;
        }

        public Criteria andOrderCreatePeopleEqualTo(String value) {
            addCriterion("order_create_people =", value, "orderCreatePeople");
            return (Criteria) this;
        }

        public Criteria andOrderCreatePeopleNotEqualTo(String value) {
            addCriterion("order_create_people <>", value, "orderCreatePeople");
            return (Criteria) this;
        }

        public Criteria andOrderCreatePeopleGreaterThan(String value) {
            addCriterion("order_create_people >", value, "orderCreatePeople");
            return (Criteria) this;
        }

        public Criteria andOrderCreatePeopleGreaterThanOrEqualTo(String value) {
            addCriterion("order_create_people >=", value, "orderCreatePeople");
            return (Criteria) this;
        }

        public Criteria andOrderCreatePeopleLessThan(String value) {
            addCriterion("order_create_people <", value, "orderCreatePeople");
            return (Criteria) this;
        }

        public Criteria andOrderCreatePeopleLessThanOrEqualTo(String value) {
            addCriterion("order_create_people <=", value, "orderCreatePeople");
            return (Criteria) this;
        }

        public Criteria andOrderCreatePeopleLike(String value) {
            addCriterion("order_create_people like", value, "orderCreatePeople");
            return (Criteria) this;
        }

        public Criteria andOrderCreatePeopleNotLike(String value) {
            addCriterion("order_create_people not like", value, "orderCreatePeople");
            return (Criteria) this;
        }

        public Criteria andOrderCreatePeopleIn(List<String> values) {
            addCriterion("order_create_people in", values, "orderCreatePeople");
            return (Criteria) this;
        }

        public Criteria andOrderCreatePeopleNotIn(List<String> values) {
            addCriterion("order_create_people not in", values, "orderCreatePeople");
            return (Criteria) this;
        }

        public Criteria andOrderCreatePeopleBetween(String value1, String value2) {
            addCriterion("order_create_people between", value1, value2, "orderCreatePeople");
            return (Criteria) this;
        }

        public Criteria andOrderCreatePeopleNotBetween(String value1, String value2) {
            addCriterion("order_create_people not between", value1, value2, "orderCreatePeople");
            return (Criteria) this;
        }

        public Criteria andOrderUpdatePeopleIsNull() {
            addCriterion("order_update_people is null");
            return (Criteria) this;
        }

        public Criteria andOrderUpdatePeopleIsNotNull() {
            addCriterion("order_update_people is not null");
            return (Criteria) this;
        }

        public Criteria andOrderUpdatePeopleEqualTo(String value) {
            addCriterion("order_update_people =", value, "orderUpdatePeople");
            return (Criteria) this;
        }

        public Criteria andOrderUpdatePeopleNotEqualTo(String value) {
            addCriterion("order_update_people <>", value, "orderUpdatePeople");
            return (Criteria) this;
        }

        public Criteria andOrderUpdatePeopleGreaterThan(String value) {
            addCriterion("order_update_people >", value, "orderUpdatePeople");
            return (Criteria) this;
        }

        public Criteria andOrderUpdatePeopleGreaterThanOrEqualTo(String value) {
            addCriterion("order_update_people >=", value, "orderUpdatePeople");
            return (Criteria) this;
        }

        public Criteria andOrderUpdatePeopleLessThan(String value) {
            addCriterion("order_update_people <", value, "orderUpdatePeople");
            return (Criteria) this;
        }

        public Criteria andOrderUpdatePeopleLessThanOrEqualTo(String value) {
            addCriterion("order_update_people <=", value, "orderUpdatePeople");
            return (Criteria) this;
        }

        public Criteria andOrderUpdatePeopleLike(String value) {
            addCriterion("order_update_people like", value, "orderUpdatePeople");
            return (Criteria) this;
        }

        public Criteria andOrderUpdatePeopleNotLike(String value) {
            addCriterion("order_update_people not like", value, "orderUpdatePeople");
            return (Criteria) this;
        }

        public Criteria andOrderUpdatePeopleIn(List<String> values) {
            addCriterion("order_update_people in", values, "orderUpdatePeople");
            return (Criteria) this;
        }

        public Criteria andOrderUpdatePeopleNotIn(List<String> values) {
            addCriterion("order_update_people not in", values, "orderUpdatePeople");
            return (Criteria) this;
        }

        public Criteria andOrderUpdatePeopleBetween(String value1, String value2) {
            addCriterion("order_update_people between", value1, value2, "orderUpdatePeople");
            return (Criteria) this;
        }

        public Criteria andOrderUpdatePeopleNotBetween(String value1, String value2) {
            addCriterion("order_update_people not between", value1, value2, "orderUpdatePeople");
            return (Criteria) this;
        }

        public Criteria andTimesOfPaymentIsNull() {
            addCriterion("times_of_payment is null");
            return (Criteria) this;
        }

        public Criteria andTimesOfPaymentIsNotNull() {
            addCriterion("times_of_payment is not null");
            return (Criteria) this;
        }

        public Criteria andTimesOfPaymentEqualTo(String value) {
            addCriterion("times_of_payment =", value, "timesOfPayment");
            return (Criteria) this;
        }

        public Criteria andTimesOfPaymentNotEqualTo(String value) {
            addCriterion("times_of_payment <>", value, "timesOfPayment");
            return (Criteria) this;
        }

        public Criteria andTimesOfPaymentGreaterThan(String value) {
            addCriterion("times_of_payment >", value, "timesOfPayment");
            return (Criteria) this;
        }

        public Criteria andTimesOfPaymentGreaterThanOrEqualTo(String value) {
            addCriterion("times_of_payment >=", value, "timesOfPayment");
            return (Criteria) this;
        }

        public Criteria andTimesOfPaymentLessThan(String value) {
            addCriterion("times_of_payment <", value, "timesOfPayment");
            return (Criteria) this;
        }

        public Criteria andTimesOfPaymentLessThanOrEqualTo(String value) {
            addCriterion("times_of_payment <=", value, "timesOfPayment");
            return (Criteria) this;
        }

        public Criteria andTimesOfPaymentLike(String value) {
            addCriterion("times_of_payment like", value, "timesOfPayment");
            return (Criteria) this;
        }

        public Criteria andTimesOfPaymentNotLike(String value) {
            addCriterion("times_of_payment not like", value, "timesOfPayment");
            return (Criteria) this;
        }

        public Criteria andTimesOfPaymentIn(List<String> values) {
            addCriterion("times_of_payment in", values, "timesOfPayment");
            return (Criteria) this;
        }

        public Criteria andTimesOfPaymentNotIn(List<String> values) {
            addCriterion("times_of_payment not in", values, "timesOfPayment");
            return (Criteria) this;
        }

        public Criteria andTimesOfPaymentBetween(String value1, String value2) {
            addCriterion("times_of_payment between", value1, value2, "timesOfPayment");
            return (Criteria) this;
        }

        public Criteria andTimesOfPaymentNotBetween(String value1, String value2) {
            addCriterion("times_of_payment not between", value1, value2, "timesOfPayment");
            return (Criteria) this;
        }

        public Criteria andWhetherHaveMembershipCardIsNull() {
            addCriterion("whether_have_membership_card is null");
            return (Criteria) this;
        }

        public Criteria andWhetherHaveMembershipCardIsNotNull() {
            addCriterion("whether_have_membership_card is not null");
            return (Criteria) this;
        }

        public Criteria andWhetherHaveMembershipCardEqualTo(String value) {
            addCriterion("whether_have_membership_card =", value, "whetherHaveMembershipCard");
            return (Criteria) this;
        }

        public Criteria andWhetherHaveMembershipCardNotEqualTo(String value) {
            addCriterion("whether_have_membership_card <>", value, "whetherHaveMembershipCard");
            return (Criteria) this;
        }

        public Criteria andWhetherHaveMembershipCardGreaterThan(String value) {
            addCriterion("whether_have_membership_card >", value, "whetherHaveMembershipCard");
            return (Criteria) this;
        }

        public Criteria andWhetherHaveMembershipCardGreaterThanOrEqualTo(String value) {
            addCriterion("whether_have_membership_card >=", value, "whetherHaveMembershipCard");
            return (Criteria) this;
        }

        public Criteria andWhetherHaveMembershipCardLessThan(String value) {
            addCriterion("whether_have_membership_card <", value, "whetherHaveMembershipCard");
            return (Criteria) this;
        }

        public Criteria andWhetherHaveMembershipCardLessThanOrEqualTo(String value) {
            addCriterion("whether_have_membership_card <=", value, "whetherHaveMembershipCard");
            return (Criteria) this;
        }

        public Criteria andWhetherHaveMembershipCardLike(String value) {
            addCriterion("whether_have_membership_card like", value, "whetherHaveMembershipCard");
            return (Criteria) this;
        }

        public Criteria andWhetherHaveMembershipCardNotLike(String value) {
            addCriterion("whether_have_membership_card not like", value, "whetherHaveMembershipCard");
            return (Criteria) this;
        }

        public Criteria andWhetherHaveMembershipCardIn(List<String> values) {
            addCriterion("whether_have_membership_card in", values, "whetherHaveMembershipCard");
            return (Criteria) this;
        }

        public Criteria andWhetherHaveMembershipCardNotIn(List<String> values) {
            addCriterion("whether_have_membership_card not in", values, "whetherHaveMembershipCard");
            return (Criteria) this;
        }

        public Criteria andWhetherHaveMembershipCardBetween(String value1, String value2) {
            addCriterion("whether_have_membership_card between", value1, value2, "whetherHaveMembershipCard");
            return (Criteria) this;
        }

        public Criteria andWhetherHaveMembershipCardNotBetween(String value1, String value2) {
            addCriterion("whether_have_membership_card not between", value1, value2, "whetherHaveMembershipCard");
            return (Criteria) this;
        }

        public Criteria andWhetherHasInvoicedIsNull() {
            addCriterion("whether_has_invoiced is null");
            return (Criteria) this;
        }

        public Criteria andWhetherHasInvoicedIsNotNull() {
            addCriterion("whether_has_invoiced is not null");
            return (Criteria) this;
        }

        public Criteria andWhetherHasInvoicedEqualTo(String value) {
            addCriterion("whether_has_invoiced =", value, "whetherHasInvoiced");
            return (Criteria) this;
        }

        public Criteria andWhetherHasInvoicedNotEqualTo(String value) {
            addCriterion("whether_has_invoiced <>", value, "whetherHasInvoiced");
            return (Criteria) this;
        }

        public Criteria andWhetherHasInvoicedGreaterThan(String value) {
            addCriterion("whether_has_invoiced >", value, "whetherHasInvoiced");
            return (Criteria) this;
        }

        public Criteria andWhetherHasInvoicedGreaterThanOrEqualTo(String value) {
            addCriterion("whether_has_invoiced >=", value, "whetherHasInvoiced");
            return (Criteria) this;
        }

        public Criteria andWhetherHasInvoicedLessThan(String value) {
            addCriterion("whether_has_invoiced <", value, "whetherHasInvoiced");
            return (Criteria) this;
        }

        public Criteria andWhetherHasInvoicedLessThanOrEqualTo(String value) {
            addCriterion("whether_has_invoiced <=", value, "whetherHasInvoiced");
            return (Criteria) this;
        }

        public Criteria andWhetherHasInvoicedLike(String value) {
            addCriterion("whether_has_invoiced like", value, "whetherHasInvoiced");
            return (Criteria) this;
        }

        public Criteria andWhetherHasInvoicedNotLike(String value) {
            addCriterion("whether_has_invoiced not like", value, "whetherHasInvoiced");
            return (Criteria) this;
        }

        public Criteria andWhetherHasInvoicedIn(List<String> values) {
            addCriterion("whether_has_invoiced in", values, "whetherHasInvoiced");
            return (Criteria) this;
        }

        public Criteria andWhetherHasInvoicedNotIn(List<String> values) {
            addCriterion("whether_has_invoiced not in", values, "whetherHasInvoiced");
            return (Criteria) this;
        }

        public Criteria andWhetherHasInvoicedBetween(String value1, String value2) {
            addCriterion("whether_has_invoiced between", value1, value2, "whetherHasInvoiced");
            return (Criteria) this;
        }

        public Criteria andWhetherHasInvoicedNotBetween(String value1, String value2) {
            addCriterion("whether_has_invoiced not between", value1, value2, "whetherHasInvoiced");
            return (Criteria) this;
        }

        public Criteria andInvoiceNumberIsNull() {
            addCriterion("invoice_number is null");
            return (Criteria) this;
        }

        public Criteria andInvoiceNumberIsNotNull() {
            addCriterion("invoice_number is not null");
            return (Criteria) this;
        }

        public Criteria andInvoiceNumberEqualTo(String value) {
            addCriterion("invoice_number =", value, "invoiceNumber");
            return (Criteria) this;
        }

        public Criteria andInvoiceNumberNotEqualTo(String value) {
            addCriterion("invoice_number <>", value, "invoiceNumber");
            return (Criteria) this;
        }

        public Criteria andInvoiceNumberGreaterThan(String value) {
            addCriterion("invoice_number >", value, "invoiceNumber");
            return (Criteria) this;
        }

        public Criteria andInvoiceNumberGreaterThanOrEqualTo(String value) {
            addCriterion("invoice_number >=", value, "invoiceNumber");
            return (Criteria) this;
        }

        public Criteria andInvoiceNumberLessThan(String value) {
            addCriterion("invoice_number <", value, "invoiceNumber");
            return (Criteria) this;
        }

        public Criteria andInvoiceNumberLessThanOrEqualTo(String value) {
            addCriterion("invoice_number <=", value, "invoiceNumber");
            return (Criteria) this;
        }

        public Criteria andInvoiceNumberLike(String value) {
            addCriterion("invoice_number like", value, "invoiceNumber");
            return (Criteria) this;
        }

        public Criteria andInvoiceNumberNotLike(String value) {
            addCriterion("invoice_number not like", value, "invoiceNumber");
            return (Criteria) this;
        }

        public Criteria andInvoiceNumberIn(List<String> values) {
            addCriterion("invoice_number in", values, "invoiceNumber");
            return (Criteria) this;
        }

        public Criteria andInvoiceNumberNotIn(List<String> values) {
            addCriterion("invoice_number not in", values, "invoiceNumber");
            return (Criteria) this;
        }

        public Criteria andInvoiceNumberBetween(String value1, String value2) {
            addCriterion("invoice_number between", value1, value2, "invoiceNumber");
            return (Criteria) this;
        }

        public Criteria andInvoiceNumberNotBetween(String value1, String value2) {
            addCriterion("invoice_number not between", value1, value2, "invoiceNumber");
            return (Criteria) this;
        }

        public Criteria andInvoiceAmountIsNull() {
            addCriterion("invoice_amount is null");
            return (Criteria) this;
        }

        public Criteria andInvoiceAmountIsNotNull() {
            addCriterion("invoice_amount is not null");
            return (Criteria) this;
        }

        public Criteria andInvoiceAmountEqualTo(String value) {
            addCriterion("invoice_amount =", value, "invoiceAmount");
            return (Criteria) this;
        }

        public Criteria andInvoiceAmountNotEqualTo(String value) {
            addCriterion("invoice_amount <>", value, "invoiceAmount");
            return (Criteria) this;
        }

        public Criteria andInvoiceAmountGreaterThan(String value) {
            addCriterion("invoice_amount >", value, "invoiceAmount");
            return (Criteria) this;
        }

        public Criteria andInvoiceAmountGreaterThanOrEqualTo(String value) {
            addCriterion("invoice_amount >=", value, "invoiceAmount");
            return (Criteria) this;
        }

        public Criteria andInvoiceAmountLessThan(String value) {
            addCriterion("invoice_amount <", value, "invoiceAmount");
            return (Criteria) this;
        }

        public Criteria andInvoiceAmountLessThanOrEqualTo(String value) {
            addCriterion("invoice_amount <=", value, "invoiceAmount");
            return (Criteria) this;
        }

        public Criteria andInvoiceAmountLike(String value) {
            addCriterion("invoice_amount like", value, "invoiceAmount");
            return (Criteria) this;
        }

        public Criteria andInvoiceAmountNotLike(String value) {
            addCriterion("invoice_amount not like", value, "invoiceAmount");
            return (Criteria) this;
        }

        public Criteria andInvoiceAmountIn(List<String> values) {
            addCriterion("invoice_amount in", values, "invoiceAmount");
            return (Criteria) this;
        }

        public Criteria andInvoiceAmountNotIn(List<String> values) {
            addCriterion("invoice_amount not in", values, "invoiceAmount");
            return (Criteria) this;
        }

        public Criteria andInvoiceAmountBetween(String value1, String value2) {
            addCriterion("invoice_amount between", value1, value2, "invoiceAmount");
            return (Criteria) this;
        }

        public Criteria andInvoiceAmountNotBetween(String value1, String value2) {
            addCriterion("invoice_amount not between", value1, value2, "invoiceAmount");
            return (Criteria) this;
        }

        public Criteria andWhetherDiscountAmountApprovedIsNull() {
            addCriterion("whether_discount_amount_approved is null");
            return (Criteria) this;
        }

        public Criteria andWhetherDiscountAmountApprovedIsNotNull() {
            addCriterion("whether_discount_amount_approved is not null");
            return (Criteria) this;
        }

        public Criteria andWhetherDiscountAmountApprovedEqualTo(String value) {
            addCriterion("whether_discount_amount_approved =", value, "whetherDiscountAmountApproved");
            return (Criteria) this;
        }

        public Criteria andWhetherDiscountAmountApprovedNotEqualTo(String value) {
            addCriterion("whether_discount_amount_approved <>", value, "whetherDiscountAmountApproved");
            return (Criteria) this;
        }

        public Criteria andWhetherDiscountAmountApprovedGreaterThan(String value) {
            addCriterion("whether_discount_amount_approved >", value, "whetherDiscountAmountApproved");
            return (Criteria) this;
        }

        public Criteria andWhetherDiscountAmountApprovedGreaterThanOrEqualTo(String value) {
            addCriterion("whether_discount_amount_approved >=", value, "whetherDiscountAmountApproved");
            return (Criteria) this;
        }

        public Criteria andWhetherDiscountAmountApprovedLessThan(String value) {
            addCriterion("whether_discount_amount_approved <", value, "whetherDiscountAmountApproved");
            return (Criteria) this;
        }

        public Criteria andWhetherDiscountAmountApprovedLessThanOrEqualTo(String value) {
            addCriterion("whether_discount_amount_approved <=", value, "whetherDiscountAmountApproved");
            return (Criteria) this;
        }

        public Criteria andWhetherDiscountAmountApprovedLike(String value) {
            addCriterion("whether_discount_amount_approved like", value, "whetherDiscountAmountApproved");
            return (Criteria) this;
        }

        public Criteria andWhetherDiscountAmountApprovedNotLike(String value) {
            addCriterion("whether_discount_amount_approved not like", value, "whetherDiscountAmountApproved");
            return (Criteria) this;
        }

        public Criteria andWhetherDiscountAmountApprovedIn(List<String> values) {
            addCriterion("whether_discount_amount_approved in", values, "whetherDiscountAmountApproved");
            return (Criteria) this;
        }

        public Criteria andWhetherDiscountAmountApprovedNotIn(List<String> values) {
            addCriterion("whether_discount_amount_approved not in", values, "whetherDiscountAmountApproved");
            return (Criteria) this;
        }

        public Criteria andWhetherDiscountAmountApprovedBetween(String value1, String value2) {
            addCriterion("whether_discount_amount_approved between", value1, value2, "whetherDiscountAmountApproved");
            return (Criteria) this;
        }

        public Criteria andWhetherDiscountAmountApprovedNotBetween(String value1, String value2) {
            addCriterion("whether_discount_amount_approved not between", value1, value2, "whetherDiscountAmountApproved");
            return (Criteria) this;
        }

        public Criteria andWhetherDiscountApprovedIsNull() {
            addCriterion("whether_discount_approved is null");
            return (Criteria) this;
        }

        public Criteria andWhetherDiscountApprovedIsNotNull() {
            addCriterion("whether_discount_approved is not null");
            return (Criteria) this;
        }

        public Criteria andWhetherDiscountApprovedEqualTo(String value) {
            addCriterion("whether_discount_approved =", value, "whetherDiscountApproved");
            return (Criteria) this;
        }

        public Criteria andWhetherDiscountApprovedNotEqualTo(String value) {
            addCriterion("whether_discount_approved <>", value, "whetherDiscountApproved");
            return (Criteria) this;
        }

        public Criteria andWhetherDiscountApprovedGreaterThan(String value) {
            addCriterion("whether_discount_approved >", value, "whetherDiscountApproved");
            return (Criteria) this;
        }

        public Criteria andWhetherDiscountApprovedGreaterThanOrEqualTo(String value) {
            addCriterion("whether_discount_approved >=", value, "whetherDiscountApproved");
            return (Criteria) this;
        }

        public Criteria andWhetherDiscountApprovedLessThan(String value) {
            addCriterion("whether_discount_approved <", value, "whetherDiscountApproved");
            return (Criteria) this;
        }

        public Criteria andWhetherDiscountApprovedLessThanOrEqualTo(String value) {
            addCriterion("whether_discount_approved <=", value, "whetherDiscountApproved");
            return (Criteria) this;
        }

        public Criteria andWhetherDiscountApprovedLike(String value) {
            addCriterion("whether_discount_approved like", value, "whetherDiscountApproved");
            return (Criteria) this;
        }

        public Criteria andWhetherDiscountApprovedNotLike(String value) {
            addCriterion("whether_discount_approved not like", value, "whetherDiscountApproved");
            return (Criteria) this;
        }

        public Criteria andWhetherDiscountApprovedIn(List<String> values) {
            addCriterion("whether_discount_approved in", values, "whetherDiscountApproved");
            return (Criteria) this;
        }

        public Criteria andWhetherDiscountApprovedNotIn(List<String> values) {
            addCriterion("whether_discount_approved not in", values, "whetherDiscountApproved");
            return (Criteria) this;
        }

        public Criteria andWhetherDiscountApprovedBetween(String value1, String value2) {
            addCriterion("whether_discount_approved between", value1, value2, "whetherDiscountApproved");
            return (Criteria) this;
        }

        public Criteria andWhetherDiscountApprovedNotBetween(String value1, String value2) {
            addCriterion("whether_discount_approved not between", value1, value2, "whetherDiscountApproved");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdIsNull() {
            addCriterion("create_people_id is null");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdIsNotNull() {
            addCriterion("create_people_id is not null");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdEqualTo(String value) {
            addCriterion("create_people_id =", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdNotEqualTo(String value) {
            addCriterion("create_people_id <>", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdGreaterThan(String value) {
            addCriterion("create_people_id >", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdGreaterThanOrEqualTo(String value) {
            addCriterion("create_people_id >=", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdLessThan(String value) {
            addCriterion("create_people_id <", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdLessThanOrEqualTo(String value) {
            addCriterion("create_people_id <=", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdLike(String value) {
            addCriterion("create_people_id like", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdNotLike(String value) {
            addCriterion("create_people_id not like", value, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdIn(List<String> values) {
            addCriterion("create_people_id in", values, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdNotIn(List<String> values) {
            addCriterion("create_people_id not in", values, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdBetween(String value1, String value2) {
            addCriterion("create_people_id between", value1, value2, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreatePeopleIdNotBetween(String value1, String value2) {
            addCriterion("create_people_id not between", value1, value2, "createPeopleId");
            return (Criteria) this;
        }

        public Criteria andCreateTmIsNull() {
            addCriterion("create_tm is null");
            return (Criteria) this;
        }

        public Criteria andCreateTmIsNotNull() {
            addCriterion("create_tm is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTmEqualTo(Date value) {
            addCriterion("create_tm =", value, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmNotEqualTo(Date value) {
            addCriterion("create_tm <>", value, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmGreaterThan(Date value) {
            addCriterion("create_tm >", value, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmGreaterThanOrEqualTo(Date value) {
            addCriterion("create_tm >=", value, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmLessThan(Date value) {
            addCriterion("create_tm <", value, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmLessThanOrEqualTo(Date value) {
            addCriterion("create_tm <=", value, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmIn(List<Date> values) {
            addCriterion("create_tm in", values, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmNotIn(List<Date> values) {
            addCriterion("create_tm not in", values, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmBetween(Date value1, Date value2) {
            addCriterion("create_tm between", value1, value2, "createTm");
            return (Criteria) this;
        }

        public Criteria andCreateTmNotBetween(Date value1, Date value2) {
            addCriterion("create_tm not between", value1, value2, "createTm");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdIsNull() {
            addCriterion("update_people_id is null");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdIsNotNull() {
            addCriterion("update_people_id is not null");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdEqualTo(String value) {
            addCriterion("update_people_id =", value, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdNotEqualTo(String value) {
            addCriterion("update_people_id <>", value, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdGreaterThan(String value) {
            addCriterion("update_people_id >", value, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdGreaterThanOrEqualTo(String value) {
            addCriterion("update_people_id >=", value, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdLessThan(String value) {
            addCriterion("update_people_id <", value, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdLessThanOrEqualTo(String value) {
            addCriterion("update_people_id <=", value, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdLike(String value) {
            addCriterion("update_people_id like", value, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdNotLike(String value) {
            addCriterion("update_people_id not like", value, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdIn(List<String> values) {
            addCriterion("update_people_id in", values, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdNotIn(List<String> values) {
            addCriterion("update_people_id not in", values, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdBetween(String value1, String value2) {
            addCriterion("update_people_id between", value1, value2, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdatePeopleIdNotBetween(String value1, String value2) {
            addCriterion("update_people_id not between", value1, value2, "updatePeopleId");
            return (Criteria) this;
        }

        public Criteria andUpdateTmIsNull() {
            addCriterion("update_tm is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTmIsNotNull() {
            addCriterion("update_tm is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTmEqualTo(Date value) {
            addCriterion("update_tm =", value, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmNotEqualTo(Date value) {
            addCriterion("update_tm <>", value, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmGreaterThan(Date value) {
            addCriterion("update_tm >", value, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmGreaterThanOrEqualTo(Date value) {
            addCriterion("update_tm >=", value, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmLessThan(Date value) {
            addCriterion("update_tm <", value, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmLessThanOrEqualTo(Date value) {
            addCriterion("update_tm <=", value, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmIn(List<Date> values) {
            addCriterion("update_tm in", values, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmNotIn(List<Date> values) {
            addCriterion("update_tm not in", values, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmBetween(Date value1, Date value2) {
            addCriterion("update_tm between", value1, value2, "updateTm");
            return (Criteria) this;
        }

        public Criteria andUpdateTmNotBetween(Date value1, Date value2) {
            addCriterion("update_tm not between", value1, value2, "updateTm");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusIsNull() {
            addCriterion("delete_status is null");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusIsNotNull() {
            addCriterion("delete_status is not null");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusEqualTo(Short value) {
            addCriterion("delete_status =", value, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusNotEqualTo(Short value) {
            addCriterion("delete_status <>", value, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusGreaterThan(Short value) {
            addCriterion("delete_status >", value, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusGreaterThanOrEqualTo(Short value) {
            addCriterion("delete_status >=", value, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusLessThan(Short value) {
            addCriterion("delete_status <", value, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusLessThanOrEqualTo(Short value) {
            addCriterion("delete_status <=", value, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusIn(List<Short> values) {
            addCriterion("delete_status in", values, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusNotIn(List<Short> values) {
            addCriterion("delete_status not in", values, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusBetween(Short value1, Short value2) {
            addCriterion("delete_status between", value1, value2, "deleteStatus");
            return (Criteria) this;
        }

        public Criteria andDeleteStatusNotBetween(Short value1, Short value2) {
            addCriterion("delete_status not between", value1, value2, "deleteStatus");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {
        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}